SQL · Regular expressions and text search

regexp_replace()

Replaces matches of a regular expression. PostgreSQL.

sqlRunnable example sql course

Syntax

regexp_replace(text, pattern, replacement, flags)

Example

Open in the lab

-- PostgreSQL
-- SELECT regexp_replace('a-b-c', '-', ' ', 'g');

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