Hi Mark, > Am 13.01.2020 um 20:39 schrieb Mark Wieder via use-livecode > <use-livecode@lists.runrev.com>: > > On 1/13/20 11:03 AM, Klaus major-k via use-livecode 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. > > Single command? No.
well, I guessed. > But you can ahead of time create a virtual table to allow full-text searching > without regard to whereness. The current LC version is linked with sqlite > 3.28. > <https://hashnode.com/post/sqlite-fts5-full-text-searching-cjmklqx50000d6is2lkuspn09> Great, thanks a lot for this link! > -- > Mark Wieder 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
