SQL · Regular expressions and text search

regexp_match()

Returns the first match of a regular expression. PostgreSQL.

sqlRunnable example sql course

Syntax

regexp_match(text, pattern)

Example

Open in the lab

-- PostgreSQL
-- SELECT regexp_match('css-16', '(\w+)-(\d+)');

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