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.
Database has two entries:
1. $searchKey = "An" - The code works fine and returns 'Andy Johnson'
2. $searchKey = "For" - Returns Null; however I want it to return "Paul Ford"