Thanks, this one does work.
- Original Message -
From: "Dan Baker" <[EMAIL PROTECTED]>
To:
Sent: Thursday, December 07, 2006 6:24 PM
Subject: Re: [sqlite] Searching for data
I do this in the following way:
SELECT * FROM tbl WHERE
(cola LIKE '%hello%' OR c
I do this in the following way:
SELECT * FROM tbl WHERE
(cola LIKE '%hello%' OR colb LIKE '%hello%' OR colc LIKE '%hello%')
AND
(cola LIKE '%juan%' OR colb LIKE '%juan%' OR colc LIKE '%juan%')
AND
(cola LIKE '%casa%' OR colb LIKE '%casa%' OR colc LIKE '%casa%')
This will return all records that
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 t
3 matches
Mail list logo
