mysql query help in selecting top votes
Posted
by moustafa
on Stack Overflow
See other posts from Stack Overflow
or by moustafa
Published on 2010-03-31T12:33:17Z
Indexed on
2010/03/31
12:43 UTC
Read the original article
Hit count: 236
mysql
i have table posts
and posts_votes
in posts_votes
i have id
and post_id
and vote
now i want select from posts where have top votes count in last 1 day using this to set the time
from_unixtime(post_date) >= SUBDATE(NOW(),1)
thanks in advance
© Stack Overflow or respective owner