Search database for part of a text input
Posted: Sun Oct 30, 2005 4:49 pm
Lets say i had a database of member information and I wanted to search the name field for 'Ryan' to find all the Ryans regardless of the last name.
what would be the mysql query to do that with?
I was thinking it would be
or something close but no combination of that i have tried seems to work for me.
what would be the mysql query to do that with?
I was thinking it would be
Code: Select all
SELECT * FROM members_page WHERE name = 'ryan *';