Link to home
Start Free TrialLog in
Avatar of Luey
LueyFlag for United States of America

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


"SELECT * FROM members WHERE mem_first_name = '$search'";

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of MrHswede
MrHswede
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Luey

ASKER

Yes,  I ended up using LIKE
"SELECT * FROM members WHERE mem_first_name LIKE '$search%'"