Even easier: SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE ‘%mysearchtermhere%’)
Sean Cole Pi Digital Prod Ltd >> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode >> <use-livecode@lists.runrev.com> wrote: > 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 _______________________________________________ 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
