Using SELECT

[jimjiminyjimjim]

I'm using the following code to query a MySQL database:

$query = "SELECT * FROM cars
WHERE model LIKE '%".$search."%' ORDER BY id";

but I don't want to just search the field "model" I want to search any of the columns in the table called "cars".

I've tried this:

$query = "SELECT FROM cars
WHERE LIKE '%".$search."%' ORDER BY id";

but that doesn't work. Can someone help me with the right code I am looking for?

Thanks very much

[thorpe]

$query = "SELECT * FROM cars WHERE model LIKE '%$search%' || anotherfield LIKE '%$search%' || another LIKE '%$search%' ORDER BY id";

[jimjiminyjimjim]

$query = "SELECT * FROM cars WHERE model LIKE '%".$search."%' || make LIKE '%".$search."%' ORDER BY id";

I've tried this and it doesn't seem to search the make field?

The script still manages to search the model field though. Any suggestions?