This week's book giveaways are in the Scala and Android forums.
We're giving away four copies each of Machine Learning Systems: Designs that scale and Xamarin in Action: Creating native cross-platform mobile apps and have the authors on-line!
See this thread and this one for details.
Win a copy of Machine Learning Systems: Designs that scale this week in the Scala forum
or Xamarin in Action: Creating native cross-platform mobile apps in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

CONTAINS keyword in SQL  RSS feed

 
Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
 
Ranch Hand
Posts: 15304
6
Chrome IntelliJ IDE Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jennifer Sohl
Ranch Hand
Posts: 455
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
I child proofed my house but they still get in. Distract them with this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!