SELECT FROM - question

[stualk]

I want to do a 'SELECT * from db' query where the database contains certains words. How do I do this?

For example, in pseudo:

"Select* from db where FIELD contains the words 'word1','word2','word3'" etc

Is this possible?

[xsist10]

[code]
SELECT * FROM tab WHERE field LIKE "%word1%" AND field LIKE "%word2%" AND field LIKE "%word3%";
[/code]