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 enumer

LIKE search on several fields

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 CON

Selecting rows issue

Hello, I got two tables containing following data : table1 -- id -- 2 3 2 2 table2 -- id | label -- 1 | one 2 | two 3 | three 4 | four I would like to select table2's rows that got at less one occurrence in table1, ie (2, two) and (3, three). That I tried was the follow