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
____________________________________________________________________
ambassa...@fourthworld.com http://www.FourthWorld.com
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
