stualk Posted October 19, 2006 Share Posted October 19, 2006 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'" etcIs this possible? Quote Link to comment Share on other sites More sharing options...
xsist10 Posted October 19, 2006 Share Posted October 19, 2006 [code]SELECT * FROM tab WHERE field LIKE "%word1%" AND field LIKE "%word2%" AND field LIKE "%word3%";[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.