[sqlite] Searching a table of patterns

2016-03-28 Thread Simon Slavin
On 28 Mar 2016, at 1:35am, David Rayna 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. One usually sees SELECT id FR

[sqlite] Searching a table of patterns

2016-03-27 Thread Richard Hipp
On 3/27/16, David Rayna 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

[sqlite] Searching a table of patterns

2016-03-27 Thread David Rayna
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. I was wondering if anyone else has come across this and if a small change to sqlite mig