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 > <[email protected]> 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 > [email protected] > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
