PostgreSQL

PostgreSQL LIKE

Search text values using wildcard patterns.

Match text patterns

SELECT * FROM products
WHERE name LIKE 'Lap%';

% matches any number of characters and _ matches one character. PostgreSQL's ILIKE performs a case-insensitive match.

SELECT * FROM products
WHERE name ILIKE '%book%';