SQL WHERE question...?

[Chud37]

Hello,

 

I want to return more than one row, but specific rows with my SQL query, So i figured i would try:

 

SELECT * FROM database WHERE ID='2' AND ID='3'.

 

But this doesnt work.  Is there a way to get specific set rows returned?

 

I might try: WHERE ID='2' AND WHERE ID='3'..

 

but im not sure.

 

Thanks for any help.

 

~Chud37

[Pikachu2000]

ID can't be equal to both 2 AND 3. ID can equal 2 OR 3.

[nealgseattle]

There are a couple of ways to do this.

 

Use a BETWEEN in your WHERE clause.  BETWEEN includes the values that are included:

    SELECT * FROM database WHERE ID BETWEEN 2 AND 3;

 

Use an IN in your WHERE clause:

    SELECT * FROM database WHERE ID IN (2,3);