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.
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>
--
Mark Wieder
ahsoftw...@gmail.com
_______________________________________________
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