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) > 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. -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de) Zülpicher Str. 47, 50674 Cologne Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786 My public PGP key is available at http://pgp.mit.edu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
