SELECT * FROM (SELECT * FROM `test` WHERE 1 ORDER BY id DESC ) AS t GROUP BY name
lz那样岂不是更加的麻烦的么,group by一般都是用来统计的,不能用于过滤
$sql = "select cdb_forums.name,cdb_threads.tid,cdb_threads.fid,cdb_threads.subject from cdb_forums left join cdb_threads on cdb_forums.fid = cdb_threads.fid order by cdb_threads.tid desc limit 0,3";
select * from tablename where id=4 and name like 'zhang%'
SELECT *
FROM (SELECT *
FROM `test`
WHERE 1
ORDER BY id DESC
) AS t
GROUP BY name