Hi Sean, > Am 14.01.2020 um 02:04 schrieb Pi Digital via use-livecode > <use-livecode@lists.runrev.com>: > > 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 >>> <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%" >>> ... >>> ... 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