Searching all columns for a string

[d0m1n1c]

Hi,

I was wondering how i would go about seaching all columns for a string.

i tried this:

SELECT FROM artists WHERE LIKE '%$search%'

But it doesnt work...

Any ideas?

Thanks

Dom

[dnast]

You'll have to name each field.

SELECT * FROM `artists` WHERE `firstname` LIKE '%$search%' OR `lastname` LIKE '%$search%' ...