Hmm. You might be best off using the FIND_IN_SET function (check the manual at mysql.com for more information).
In short, if you replace all spaces in your string to search with commas, you should be able to do something like: SELECT * FROM xyz WHERE FIND_IN_SET(test_column, your string here) > 0 Not 100% sure, as I haven't tried quite this approach! Another, more long winded way might be to explode your string out into a temporary table and compose a query which will bring back all matching rows (by multiple joins to the temporary table). FIND_IN_SET looks like a better alternative! Cheers, Matt -----Original Message----- From: Tarik ANSARI [mailto:[EMAIL PROTECTED] Sent: 10 April 2004 14:51 To: [EMAIL PROTECTED] Subject: LIKE search with different orders Hello again, To follow my previous message, the CONCAT method does works, but now my problem is to make a search where the order doesn't count : then to find members whose firstname is john, lastname smith and vice-versa. I would like to use an operator or a function for this, but I cannot enumerate all possible combinations (in this case yes, because the query only has 2 words, but with a query with 6 words it would make 6! combinations then a very long query !). Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]