How about simply: WHERE cola LIKE '%hello%juan%casa%' OR colb LIKE '%hello%juan%casa%'
Etc. RBS -----Original Message----- From: jose isaias cabrera [mailto:[EMAIL PROTECTED] Sent: 07 December 2006 22:55 To: sqlite-users@sqlite.org Subject: [sqlite] Searching for data Greetings. I have a table with many columns. I would like to find records google-like on all the records. Say, for example the searching criteria is hello juan casa I would like to have any record that has all of those tokens in any of the columns. how would I do that with a select? (imagine the table has cola, colb, colc.) thanks, josé ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------