SQL · Functions and expressions

replace()

Replaces every occurrence of a substring.

sqlRunnable example sql course

Syntax

replace(text, from, to)

Example

Open in the lab

SELECT replace('a-b-c', '-', ' ') AS cleaned;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.