mysql LIKE many search fields

[boo_lolly]

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
[code]
          $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());
[/code] how would you have that effect?