Simple(for you guys) query question. 1

[paul172]

Say I have a table with a couple of hundred records in it.

I only want to return records 1, 3, 7, 10, 14, 20, 89 etc etc....

I would assume(wrongly) that the syntax would be the following -

select * from table where field = 1, 3, 7, 10.......etc

Can someone point me in the right direction?

Thanks,
Paul

 

[simonchristieis]

try this:

select * from table where field in (1, 3, 7, 10)

 

[gradley]

select *
from table
where field IN(1,3,7,10)

You will need single quotes if string values

 

[gmmastros]

Select * from Table Where Field In (1,3,7,10....etc)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gradley]

Sorry simonchristieis!!! My typing was a little slower than yours

 

[simonchristieis]

hehe - you also placed it in a code box !

 

[paul172]

Cheers guys, it worked a treat!!!

I'll give the star to Simon as he was the quickest off the mark!