SQL(ite) question

[Bob Sneidar]

Yes, but the original question was about whether or not it could be done with a single statement. Also I am not a big fan of full text searches the way they are implemented typically. For instance, on our copier vendor's websites they of course have searches, but what I end up with are 10,000 hits and almost none of them relevant. This is because they are not ranked, and the ranking makes all the difference in the world. 

My method does not rank of course, but it is a quick one liner that gets the job done (unless you have to build the query on the fly in a repeat loop). 

Bob S


> On Jan 14, 2020, at 11:16 , Richard Gaskin via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> 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