bobsneidar at iotecdigital.com
Mon Jan 13 18:03:30 EST 2020
Actually I do this all the time.
SELECT * from MyTable where
COLUMN1 like "%mysearchtermhere%" OR
COLUMN2 like "%mysearchtermhere%" OR
COLUMN3 like "%mysearchtermhere%"
I loop through a list of columns I want to search to build the query.
> On Jan 13, 2020, at 11:03 , Klaus major-k via use-livecode <use-livecode at lists.runrev.com> 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.
> Klaus Major
> klaus at major-k.de
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode