Replaces matches of a regular expression pattern.
Syntax
REGEXP_REPLACE(src, pat [, rep ...])Example
Enter values below to update the example in real time.
address→clean_address→customers→SELECT REGEXP_REPLACE(address, 's+', ' ') AS clean_address
FROM customers;