SQL(ite) question

Mark Wieder ahsoftware at sonic.net
Mon Jan 13 14:39:03 EST 2020

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.


  Mark Wieder
  ahsoftware at gmail.com

More information about the use-livecode mailing list