[RESOLVED] Selecting multiple queries?

[iBuddy]

im trying to select a total of 9 queries in one sql:

SELECT * FROM items
WHERE id = 823 and
440 and
476 and
933 and
939 and
789 and
489 and
547 and
701

What am I doing wrong?

[NogDog]

I think you mean:

SELECT * FROM items WHERE id IN (823,440,476,933,939,789,489,547,701)

[iBuddy]

thank you sir, worked!