SQL Query needed...

[Tommm]

Hi! :)

I'm looking for a SQL query which will give me a list of all the users that have made a post on a certain day. It would be even better if the list contained no duplicate usernames (because the user posted more than once..)

Can anybody help?

Thanks!

[Marco van Herwaarden]

SELECT username FROM post WHERE dateline > <timestampbeginofday> AND dateline > <timestampendofday> GROUP BY username

[Xenon]

instead of group by, i'd use distinct:

SELECT DISTINCT username FROM post WHERE dateline > <timestampbeginofday> AND dateline > <timestampendofday>

[Tommm]

Thanks for those! I'm sorry to sound extra slow, but how I'd define a timestamp in which format?

Say I wanted to get a list of users that posted from 00:01 to 23:59

Thanks once more! <3