MySQL›String Functions›REPLACE
←RTRIM

REPLACEString Functions

INSTR→

Replaces all occurrences of a substring.

Syntax

REPLACE(str, from, to)

Example

Enter values below to update the example in real time.

phone→
phone_plain→
customers→
-- 전화번호 하이픈 제거
SELECT REPLACE(phone, '-', '') AS phone_plain
FROM customers;