Help with simple SQL query

Hi All

Can anyone tell me what this simple SQL query would be:

Find all the words "black", "dvd" and "player" from any of the fields "Product", "Brand" or "Description".

Many thanks

accelerator

try something like this

select * from table where product like '%black%' or product like '%dvd%' or product like '%player%'

the above would search the product field...continue the same with your other fields.

|||Use ofFreeTextTable might be appropriate in this case. It's not the simple query you were looking for, but may provide more meaningful results.