Im wanting to search for a given keyword in a mysql table. I want to check in every field in the table, is there a way of doing this without writing
WHERE field_name = '$search' OR field_name2 = '$search'
and repeating that for every field, because its a bit messy!