search query to search in multiple rows of table

[Shadeless]

how can i make the folowing search query searching more then only the id row? I tried different things but not seem to work, it can't be that hard.. allthough nothing seem to work for me 🙁

$query = "SELECT * FROM information WHERE id LIKE  '%".$all."%'";

With kind regards

[cahva]

$query = "SELECT * FROM information WHERE id LIKE '%".$all."%' OR field1 LIKE '%".$all."%' OR field2 LIKE '%".$all."%'... and so on.

[Shadeless]

hmm tried something like that but then it didn' t worked or was sleeping :o

because now it does work, perhaps i just did;
WHERE bla OR bla OR bla2 LIKE '%".$all."%'

anywayz it works now, thanks alot 🙂