[RESOLVED] MySQL: Query with more than one id(s)

[modpluz]

how can you make MySQL get results relating to more than 1 id(s)(say like 5, 45, 6)

[penagate]

select * from table_name where id = 5 or id = 45 or id = 6

[modpluz]

that was what i first tried when i needed to do this in the first place but it returned no results.

[kfcSmitty]

Are the ID's string or numerical data type in the database?

[{yak}]

Or, where id in(5, 45, 6). If it doesn't work you'll have to give us more to go with.

[modpluz]

sorry for replying late...

Are the ID's string or numerical data type in the database?

the id's are numerical in the database.

[visualAd]

reply #2 and reply #5 both give you a solution.

[modpluz]

yes it does... thanks
just wanted to reply to kfcSmitty's post