SELECT num_rowsFROM( SELECT @rownum := @rownum+1 AS num_rows,username FROM (SELECT @rownum:=0,username,votes from tableName)t ORDER BY votes DESC)t1 WHERE username=‘{$username}‘
mysql排行榜sql的实现
原文：http://www.cnblogs.com/bossikill/p/3526587.html
