Multiple Database Queries

[eluser]joshvermaire[/eluser]
When I use the 'WHERE IN' statement it only returns one value even though there is more than one app_id.
I did this query and it works well:

Code:

SELECT  `app_name`
FROM (
`applications`
)
WHERE  `id` =  '2'
OR  `id` =  '3'

If there are a hundred different app_id values that I'm looking for, I'm guessing there's a more efficient way to process the query than a hundred OR statements. I'm assuming that's where you want somehting like a 'WHERE IN' statement, but unfortunately it wasn't working.

Thoughts?