Easy SQL question ?

[developer]

Hello! 🙂

I do have this, which works fine:

$Query="SELECT * FROM companies WHERE name LIKE '%$searchstring%'";

Instead of searching on only the name field I would like to search on all fields in the table.

Any ideas please?

[Sxooter]

Build a query like:

select * from table where field1 like '%$word%' OR field2 like '%$word%';

[developer]

Thanks for the help. 🙂