SQL(ite) question

[Richard Gaskin]

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