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 query where the LIKE (or anything else) searches for my given strings in any order.
I'm using MySQL 4.1.11 on windows XP, if it matters.
Thanks. Micha.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
