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