MySQL/総件数取得

総件数を取得する †

SELECT SQL_CALC_FOUND_ROWS sample_id, sample_name
FROM sample
WHERE sample_id = 1
LIMIT 2;

SELECT FOUND_ROWS();

結果
+--------------+
| FOUND_ROWS() |
+--------------+
|            4 |
+--------------+

Comment †