Ive got a db with a few columns, that I would like to search through, but Im not to sure how to search through numerous columns in one db. My sql query looks some thin like this:
$query = "SELECT *FROM table WHERE column1 or column2 or column3 LIKE '%$var%';
Its seems to bring out fewer result than when I put in a simple query like:
SELECT *FROM table WHERE column1 LIKE ''%$var%';
