Hi I am using the following query:

"SELECT * FROM members WHERE name LIKE '$searchKey%';"

Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, it returns null.

Eg:
Database has two entries:
Andy Johnson
Paul Ford

1. $searchKey = "An" - The code works fine and returns 'Andy Johnson'
2. $searchKey = "For" - Returns Null; however I want it to return "Paul Ford"

Thanks

Re: MySQL 'LIKE' 80 80

put a % symbol BEFORE and AFTER the variable name:

"SELECT * FROM members WHERE name LIKE '%$searchKey%';"
Re: MySQL 'LIKE' 80 80

It works!

Thanks a lot!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.