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.
ahsoftware at gmail.com
More information about the use-livecode