Does anyone happen to know if DB2 supports the CONTAINS keyword? I can't seem to find any documentation on it in my book. If it is not supported, what would a person use get the same results as if they were using the CONTAINS keyword? Thanks for any help!
I don't know if it is supported in the same way you are wanting, but CONTAINS is a keyword. I found this in the documents provided by IBM. (Someday I am going to teach a 'How to search using Google' class ). PDF Manual
wouldn't that just be accomplished using "SELECT * FROM some_file WHERE some_field LIKE '%SOMESTRING%' " the like operator would be the standard accross most databases. Is this what you wanted to accomplish? Jamie
posted 14 years ago
When I use the keyword LIKE '%SEARCH CRITERIA%' it looks for the string in that order. I would like to search the column for 'search criteria' if it is in that order, or if one of the words is found anywhere in the column, not necessarily in that order. Such as "I am doing a search for certain criteria." This will not show up in my results if I use the keyword LIKE.
sorry, actually, i didnt get the meaning of ur searching word, actually "like", "in" keywords r there to search for a corresponding term. go for their syntax, i think those may help u . thnx bhramaresh