Database Search help

davidmyers

I need to do a search in my database for any keyword that is entered using PHP. So far what I have is this

$query="SELECT * FROM Guns WHERE brand LIKE '%$searchquery%'";

The problem with this is that I can only search in one field, in this instance the field "brand". I need a way to search multiple fields all at once. Any help?

wilku

You can consider using CONCAT ( http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat ) with all the fields you want to search from.

SELECT * FROM Guns WHERE CONCAT(brand, id, whatever) LIKE '%$searchquery%';

or multiple logical operators

SELECT * FROM Guns WHERE 
   brand LIKE '%$searchquery%'
   OR id LIKE  '%$searchquery%'
   OR whatever LIKE  '%$searchquery%'

davidmyers

Thanks, using CONCAT seems to have solved my problem. I had tried using multiple logical operators, but for some reason it wouldn't work. Thanks again for the help.