query - select multiple rows

[tonymm]

I have a table called Contacts that has a column called "id". I want to extract from that table all row data where id = specific values

i have tried the following but it doesnt work

SELECT * FROM abc.tablename WHERE id='1' AND id='2' AND id='3'

I'm obviously not an SQL person but I need to be able to extract multpile row data..

any help appreciated

tony

 

[swampBoogie]

SELECT * FROM abc.tablename WHERE id='1' or id='2' or id='3'

 

[dnoeth]

Or:
SELECT * FROM abc.tablename WHERE id IN ('1', '2', '3')

Dieter

 

[tonymm]

thanks guys

tm