Text and Date Queries

LIKE Patterns

Matching Text

LIKE filters text with simple wildcard patterns. % means any run of characters.

Program

Play the script to select file names with a chosen pattern.

like_patterns.sql 
CREATE TABLE files (name TEXT);
INSERT INTO files VALUES ('readme.md'), ('notes.txt'), ('data_jan.csv'), ('data_feb.csv');
WITH params(pattern) AS (VALUES ()) SELECT name FROM files WHERE name LIKE (SELECT pattern FROM params) ORDER BY name;

CREATE TABLE files (name TEXT);
INSERT INTO files VALUES ('readme.md'), ('notes.txt'), ('data_jan.csv'), ('data_feb.csv');
WITH params(pattern) AS (VALUES ()) SELECT name FROM files WHERE name LIKE (SELECT pattern FROM params) ORDER BY name;

CREATE TABLE files (name TEXT);
INSERT INTO files VALUES ('readme.md'), ('notes.txt'), ('data_jan.csv'), ('data_feb.csv');
WITH params(pattern) AS (VALUES ()) SELECT name FROM files WHERE name LIKE (SELECT pattern FROM params) ORDER BY name;
LIKE `LIKE` compares text with a wildcard pattern.
% `%` matches zero or more characters.
pattern parameter The `params` CTE holds the selectable pattern.