mysql LIKE many search fields
Posted: Tue Nov 28, 2006 9:50 am
what if you had many search fields to search a SQL table. for instance, if you had a SQL table with many columns (that you would search through) like first name, last name, birth date, how would you search for all three queries and return only results that matched the user's input data?
for instance, if they wanted to search for all the people in my_search_table who had the first name 'Glen' AND the last name 'Lambert' AND who have a birthdate of 02/05/82. how can this be done in the query? something like how would you have that effect?
for instance, if they wanted to search for all the people in my_search_table who had the first name 'Glen' AND the last name 'Lambert' AND who have a birthdate of 02/05/82. how can this be done in the query? something like
Code: Select all
$result = mysql_query("SELECT first_name, last_name, birth_date
FROM my_search_table
WHERE first_name LIKE '%". fname ."%' AND last_name LIKE '%". $lname ."%' AND
birth_month LIKE '%". $birth_month ."%' AND
birth_day LIKE '%". $birth_day ."%' AND
birth_year LIKE '%". $birth_year ."%'")
or die(mysql_error());