PatternMatching

SELECT * FROM pet WHERE name LIKE 'b%';
SELECT (path,when) FROM write WHERE path LIKE '/hello/world/';
SELECT * FROM pet WHERE name REGEXP '^b';