Home > Article > Backend Development > php如何满足某一种条件,只取最新的一条数据
SELECT * FROM pc_record WHERE name LIKE '小明' LIMIT 1
order by id desc
或者发布时间 desc
SELECT * FROM pc_record WHERE name LIKE '小明' order by id desc LIMIT 1
在语句后加order by id DESC
order by id desc,根据id从大到小排序,limit 1 取第一个,就是取id最大的那个,最新的那个