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]>
To: mysql@lists.mysql.com
Subject: LIKE questi
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
"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
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
