Not sure if your query works. But what should work is
SELECT * FROM table WHERE c LIKE "%word1%" and c LIKE "%word2%" and c LIKE
"%word3%";
But might be slow ...
Am Thursday 14 April 2005 13:53 schrieb Micha Berdichevsky:
> Hi group.
> I have a table with a varchar(250) column in it (let's call
I think that if you explode your words with AND it should work in any order:
SELECT * FROM table WHERE c LIKE '%word1%' AND c LIKE '%word2%' AND c LIKE
'%word3%';
but there's maybe something better to do!
From: Micha Berdichevsky <[EMAIL PROTECTED]>
Micha Berdichevsky <[EMAIL PROTECTED]> wrote on 14/04/2005 12:53:31:
> Hi group.
> I have a table with a varchar(250) column in it (let's call it c)
> I want to select values that contain a number of given words in them
> (three or more), in any words order
> I currently use
> SELECT * FROM table
Hi group.
I have a table with a varchar(250) column in it (let's call it c)
I want to select values that contain a number of given words in them
(three or more), in any words order
I currently use
SELECT * FROM table WHERE c LIKE "%word1%word2%word3%";
I was wandering if it is possible to use a qu
"RuiSMonteiro" <[EMAIL PROTECTED]> wrote on 22/09/2004 09:35:00:
> Hello there,
> I was wondering how I could make a specific type of search when the
> string has more than one word.
> Ex.-
> String = "Green Apple"
> Select * from fruits
> where
> (frui
Hello there,
I was wondering how I could make a specific type of search when the string has more
than one word.
Ex.-
String = "Green Apple"
Select * from fruits
where
(fruits.color like '%Green Apple%'
or fruits.type like '%Green Apple%')
---
V. M. Brasseur wrote:
How about...
SELECT foo FROM bar WHERE LCASE(this) = "that";
Although there are always other ways to do it, of course.
Cheers,
--V
Schalk Neethling wrote:
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE
How about...
SELECT foo FROM bar WHERE LCASE(this) = "that";
Although there are always other ways to do it, of course.
Cheers,
--V
Schalk Neethling wrote:
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE is skipping this one
If I search a field for 'doone' and one of the fields contains 'Lorna
Doone' what is the best comparator to use as LIKE is skipping this one
and I imagine '=' will do the same?
--
Kind Regards
Schalk Neethling
Web Developer.Designer.Programmer.President
Volume4.Development.Multimedia.Branding
em
