查询中有LIMIT时，如何获取总结果数？

添加一列，

total

select t.*     , (select count(*) from tbl where col = t.col) as totalfrom tbl twhere t.col = 'anything'limit 5

如 @Tim Biegeleisen所述 ：

limit

count(*)