Query Syntax

[jaymc]

Ok, basically I want to run 1 query and search for where ID rows = 5 different numbers

So essentially it is going to search the entire table and try pull out 5 different rows based on my search criteria

Is this the syntax for that

[code]SELECT *
FROM `artists`
WHERE `ID` = '1'
AND `ID` = '4'
AND `ID` = '7'
AND `ID` = '21'
AND `ID` = '51'
LIMIT 0,5[/code]

I just thought their may be another way rather than using all those ANDS

maybe something like

[code]WHERE ID = '1,4,7,21,51'[/code]

[b]Any help?[/b]

[AndyB]

[code]SELECT * FROM artists WHERE ID IN (1,4,7,21,51) LIMIT 0,5[/code]

[jaymc]

Worked