wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes simple sql help. the select command.  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "simple sql help. the select command.  " Watch "simple sql help. the select command.  " New topic

simple sql help. the select command.

bhavin ragha

Joined: Mar 28, 2012
Posts: 17
I know this is simple sql. but i am trying to do a simple select command.
the command says

this works.

but my question is how do i put multiple values in. for example where cd_id = 'cd001', 'cd005', 'cd023'
Santhosh ayiappan
Ranch Hand

Joined: Jan 30, 2007
Posts: 80

You can use the "like" in the where clause instead of "=".
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3728

Hi Bhavin, and welcome to the Ranch!

In your case, you could probably use the IN operator. I'd suggest reading some SQL tutorial, it will come in handy.

If you plan to run this statement using JDBC, you should also read a thing or two about PreparedStatement.
I agree. Here's the link: http://aspose.com/file-tools
subject: simple sql help. the select command.
It's not a secret anymore!