Suppose I have a SELECT statement like this (note - I exclusively use MySQL):
SELECT fanfics.*
FROM fanfics
WHERE fanfics.sid = 3
ORDER BY fanfics.title
LIMIT 40, 20;
Given that I have that LIMIT constraint, is there a way to determine
how many rows would have been returned if I did NOT have the LIMIT
constraint? Do I just have to do a separate SELECT statement without
the LIMIT constraint? How can I do this efficiently (a MySQL-specific
solution is fine)?
