[eduardo]

Hi

I want to search my DB for ANY word on a field.

i am using .... like '%$field%', but if the field have more than 1 word it will look only for the exact 2 words and not for any of then.

how can i do this????

thanks

[liammacg]

Are you using LIKE in your MySQL query?

Ex:

SELECT * FROM whatever WHERE whateverelse LIKE '%$field%'

I don't know if my query is all correct, but just an example. Haven't done MySQL on my own for a while.

[eduardo]

yes i am using like