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
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 WHERE
question - is it possible?
Date: Thu, 14 Apr 2005 13:53:31 +0200
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
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 it c)