query
Posted: Wed Dec 15, 2004 6:46 am
Hi all,
simple but i just cant get my brain to function.
I have a field of locations, when i search lets say for example "london", i have london stored as "london *" in the database with "*", how can i find london, so i want to only find characters with [a-z] or [A-Z] or [0-9], missing out any special characters in the where statement
select * from tbl_location where lname = '$location'
simple but i just cant get my brain to function.
I have a field of locations, when i search lets say for example "london", i have london stored as "london *" in the database with "*", how can i find london, so i want to only find characters with [a-z] or [A-Z] or [0-9], missing out any special characters in the where statement
select * from tbl_location where lname = '$location'