SQL(ite) question

[Mark Wieder]

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
  ahsoftware at gmail.com