simple sql help. the select command.

[bhavin ragha]

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'

this works.

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

[Santhosh ayiappan]

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

[Martin Vajsar]

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.