SQL(ite) question

Klaus major-k klaus at major-k.de
Mon Jan 13 14:03:52 EST 2020

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

More information about the use-livecode mailing list