mysql query multiple conditions.

[duckxtales]

Hi i want to do a mysql select with more than 1 conditions.

I have this:

select * from phpbb_posts where post_time = 1064078039;

but i want to be able to select multiple post_time's. I'm guessing it was something like this:

select * from phpbb_posts where post_time = (1064078039, 1034078039, 10640744039, 10643378039, 1064076039);

but thats obviously wrong. Anyone can help here?

thx...

[coopster]

select * from phpbb_posts where post_time IN (1064078039, 1034078039, 10640744039, 10643378039, 1064076039);

You might also want to look into the BETWEEN operator too. Might not work in this case, but comes in handy quite often!

[cameraman]

post_time IN (1064078039, 103

MAN you gotta be fast around here!