SQL · Regular expressions and text search

similar to

SQL standard pattern matching with more operators than LIKE. PostgreSQL; SQLite uses GLOB.

sqlRunnable example sql course

Syntax

text similar to pattern

Example

Open in the lab

-- PostgreSQL: SELECT 'css' SIMILAR TO 'c%';
SELECT 'css' GLOB 'c*' AS matches;

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