mysql> select * from wanyouxi where youxitag='bird' ORDER BY credits desc limit 1; +-------+------+--------+------------+---------+------------+------+-----+------+ | id | uid | gameid | youxitag| credits | dateline | type | sid | wins | +-------+------+--------+------------+---------+------------+------+-----+------+ | 49578 | 1155 | 0 | bird| 43830 | 1221623720 | 0 | 6 | 0 | +-------+------+--------+------------+---------+------------+------+-----+------+ 1 row in set (0.37 sec)
mysql> SELECT * from wanyouxi where youxijifen= (SELECT MAX(youxijifen) FROM cdb_playsgame where youxitag='bird') and youxitag='bird'; +-------+------+--------+------------+---------+------------+------+-----+------+ | id | uid | gameid | youxitag| credits | dateline | type | sid | wins | +-------+------+--------+------------+---------+------------+------+-----+------+ | 49578 | 1155 | 0 | bird| 43830 | 1221623720 | 0 | 6 | 0 | +-------+------+--------+------------+---------+------------+------+-----+------+ 1 row in set (0.30 sec)