`REPLACE`String Functions

Replaces all occurrences of a substring.

Syntax

REPLACE(str, from, to)

Enter values below to update the example in real time.

phone_number→

phone_plain→

customers→

SELECT REPLACE(phone_number, '-', '') AS phone_plain
FROM customers;