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@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 > kl...@major-k.de > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
