SQL(ite) question
Klaus major-k
klaus at major-k.de
Mon Jan 13 14:41:36 EST 2020
Hi Mark,
> Am 13.01.2020 um 20:39 schrieb Mark Wieder via use-livecode <use-livecode at 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
klaus at major-k.de
More information about the use-livecode
mailing list