SQL(ite) question

[Bob Sneidar]

Actually I do this all the time. 

SELECT * from MyTable where
   COLUMN1 like "%mysearchtermhere%" OR 
   COLUMN2 like "%mysearchtermhere%" OR 
   COLUMN3 like "%mysearchtermhere%" 

I loop through a list of columns I want to search to build the query. 

Bob S


> On Jan 13, 2020, at 11:03 , Klaus major-k via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi all,
> 
> I searched the docs of SQLite but could not find a hint.
> 
> Is it possible to create a "full text search" in SQL(ite)
> with ONE SQL command? Something like this (pseudocode):
> ...
> SELECT * from MyTable where ANY_COLUMN like "%mysearchtermhere%"
> ...
> If not, how can this be done?
> 
> You get the picture, any hints appreciated, thank you.
> 
> 
> Best
> 
> Klaus
> --
> Klaus Major
> https://www.major-k.de
> klaus at major-k.de
> 
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode