SQL · Regular expressions and text search

regexp_like()

Tests a regular expression. MySQL and Oracle; PostgreSQL uses ~.

sqlRunnable example sql course

Syntax

regexp_like(text, pattern)

Example

Open in the lab

-- PostgreSQL
-- SELECT 'css-16' ~ '\d+';

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