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: 241

Filed under:

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

Related posts about mysql