[sqlite] Searching a table of patterns

[Richard Hipp]

On 3/27/16, David Rayna <drayna at optonline.net> wrote:
> One thing I have occasionally desired is be able to search a table of
> patterns given a string that might match some rows.
> This is the reverse of searching a table of strings to find ones that
> match a pattern.

CREATE TABLE t1(a INT, pattern TEXT);
INSERT INTO t1(a,pattern) VALUES(123,'x%y');

SELECT a FROM t1 WHERE 'xyzzy' LIKE pattern;

-- 
D. Richard Hipp
drh at sqlite.org