I need to write search Query that returns the names that matches with the typed characters.. I have stored both first and last name in same column. I need to search the typed characters with both First and Last Name (" All stored in Name field, separated by space )
SELECT name FROM table WHERE name LIKE '$search%' OR name LIKE '% $search%'
Can I write this ? But this doesn't work.