Hello, I have a database with fields : - firstname - lastname
And I want to do a search from the query string "john smith" in order to find anyone having john in his firstname and smith in the lastname or smith in the firstname and john in the lastname. It tried : SELECT * FROM members WHERE CONCAT(firstname, ' ', lastname) LIKE '%john%smith%' But it doesn't work Thank you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]