Hi Sean, > Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode > <[email protected]>: > > Even easier: > > SELECT * FROM MyTable WHERE ((col1+col2+aCol1+aCol2) LIKE > ‘%mysearchtermhere%’)
aha, thank you very much, I had no idea this is possible! :-) > Sean Cole > Pi Digital Prod Ltd > >>> On 13 Jan 2020, at 23:03, Bob Sneidar via use-livecode >>> <[email protected]> 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 >>> <[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%" >>> ... >>> ... 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
