Luey
asked on
Select where only a portion of the string is known.
Is it possible to select from a table where only a portion of the string in a column is known?
Example: I type 1234 in my form field and return all data that starts with 1234. ie, 123456
Example: I type 1234 in my form field and return all data that starts with 1234. ie, 123456
"SELECT * FROM members WHERE mem_first_name = '$search'";
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"SELECT * FROM members WHERE mem_first_name LIKE '$search%'"