Paging, limit, offset, page record count, total record count efficiency

[Chris Barnes]

Is there any way that this query could return the number of rows for the whole query as well as for the page ?

SELECT a,b,c FROM d WHERE c='blaa' LIMIT 100,10;

At the moment, I'm having to run the query twice, once to get the total row count:

1) SELECT COUNT(*) FROM (SELECT a,b,c FROM d WHERE c='blaa');

Then

2) SELECT a,b,c FROM d WHERE c='blaa' LIMIT 100,10

Surely there's got to be a more efficient way of doing this ?
Surely, under the bonnet, query number 2 is actually having to take a slice of the whole set, so it already knows the total record count in there ?
But I'm probably just being a naive newb ? ;-)

Many thanks