SQL · Regular expressions and text search

regexp_matches()

Returns all matches as rows. PostgreSQL.

sqlRunnable example sql course

Syntax

regexp_matches(text, pattern, flags)

Example

Open in the lab

-- PostgreSQL
-- SELECT regexp_matches('a1 b2', '\d', 'g');

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