[sqlite] Searching a table of patterns

[Simon Slavin]

On 28 Mar 2016, at 1:35am, 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.

One usually sees

SELECT id FROM myTable WHERE columnName LIKE '%abc%'

but SQLite also handles

SELECT id FROM myTable WHERE 'abc' LIKE columnName

And put strings like '%abc%' in the column of the table.

Simon.