MySQL Search Query on two different fields
- by user181677
I need to search on two fields using LIKE function and should match also in reverse order. My table uses InnoDB which dont have Full text search.
For example, I have users table with first_name and last_name column.
I tried this SQL statement but no luck.
SELECT CONCAT(first_name, ' ', last_name) as fullname
FROM users
WHERE fullname LIKE '%doe%';
