File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
simple sql help. the select command.
Joined: Mar 28, 2012
Apr 10, 2012 04:05:24
I know this is simple sql. but i am trying to do a simple select command.
the command says
Select title from cds where cd_id = 'cd001'
but my question is how do i put multiple values in.
for example where cd_id = 'cd001', 'cd005', 'cd023'
Joined: Jan 30, 2007
Apr 10, 2012 04:10:54
You can use the "like" in the where clause instead of "=".
Joined: Aug 22, 2010
Apr 10, 2012 04:13:45
Hi Bhavin, and welcome to the Ranch!
In your case, you could probably use the
operator. I'd suggest reading some
, it will come in handy.
If you plan to run this statement using
, you should also read a thing or two about
I agree. Here's the link:
subject: simple sql help. the select command.
oracle sequence id and table data insertion
Inverse this where condition
oracle sequence id
Passing a Querystring from one page to the next
converting a mysql DATETIME (HH:mm:ss) to seconds
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015