I've recently learned that
SQL_CALC_FOUND_ROWS can give the number of rows in a table from almost any
SELECT statement. It's raw SQL syntax is
SELECT SQL_CALC_FOUND_ROWS field1, field2, ... FROM ...
Is there an existing way I can that inject that syntax into
I want to use this for creating a pager, so I'm already selecting some rows in the first place. It would be handy to get a count out of the query I'm already running. Doing a separate count query would be extra work in my case.