从PHP和MYSQL中的名字或姓氏的第一个字母开始搜索

Question

I need to search first name or last name from the beginning of characters. For example, firstname is Michael and lastname is Jordan. If I search "dan" or "hae" words, it shouldn't return result. Only if I search "mic" or "jor", it should return firstname and lastname together. Is there any way to do it with mysql ?

My following code does not return what I expect.

select * from users where (firstname like '%$searchWord%' or lastname like '%$searchWord%')

Answer 1

If you only want to search from the beginning of the word you have to place your wildcards only at the end of the condition:

SELECT * FROM `users` WHERE (`firstname` LIKE '$searchWord%' OR `lastname` LIKE '$searchWord%')