`REPLACE`String Functions

Replaces occurrences of a substring.

Syntax

REPLACE(str, from [, to])

Enter values below to update the example in real time.

phone_no→

phone_plain→

customers→

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