Searching Multiple Feilds in mysql

[Anon]

i don't know where to ask this question , but i am using php. so i guess that this shall do. i want to be able to search multiple fields in a table, how would i go about doing this. i want to be able to search first name and last name feature. thanks in advance.

[Anon]

SELECT * from tablename WHERE (firstname like '%searchwords%') OR (lastname like '%searchwords%');