ambassador at fourthworld.com
Tue Jan 14 14:16:01 EST 2020
Bob Sneidar wrote:
> 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.
Wouldn't that be a brute-force search rather than the efficiency of
SQLite's FTS index?
Fourth World Systems
Software Design and Development for the Desktop, Mobile, and the Web
Ambassador at FourthWorld.com http://www.FourthWorld.com
More information about the use-livecode