SELECT temp.* FROM(
SELECT * FROM t_kaoqin
WHERE p_id=1 AND TO_DAYS(t_kaoqin.kq_time)=TO_DAYS(NOW())
ORDER BY kq_time DESC LIMIT 0,10000
) AS temp GROUP BY temp.user_id
< END >
程序员NBA
一个有故事的程序员
或者加我微信1414200300一起讨论java技术,有什么问题群里人也可以帮你一起解决