SQL(ite) question

Richard Gaskin 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?

  Richard Gaskin
  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 mailing list