Text & patterns Scalar

regexp_replace()

If string contains the regexp pattern, replaces the matching part with replacement. A set of optional options can be set.

Arguments & returns

2 overloads

Scalar

Overload link	`string`	`pattern`	`replacement[`	Returns
#01	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR`

Scalar

Overload link	`string`	`pattern`	`replacement[`	`options]`	Returns
#02	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR`	`VARCHAR`

SELECT regexp_replace('hello', '[lo]', '-');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

Trim the edges, normalize case, and replace runs of spaces. Small functions compose into a readable cleaning step.

SELECT regexp_replace(
  lower(trim('  Summer Harvest 2026  ')),
  '\s+', '-', 'g'
) AS slug;

Haybarn WASM 1.5.5-rc3 · In your browser

Guide recipe · Run to view results.

REGEXP_REPLACE(subject, pattern, replacement, position, occurrence)

In DuckDB

REGEXP_REPLACE(subject, pattern, replacement)

REGEXP_REPLACE(subject, pattern)

In DuckDB

REGEXP_REPLACE(subject, pattern, '', 'g')