In the last episode (Jul 18), S A said:
> Is there some way to take the following 2 queries & make them into
> one ?
Nope. Do them separately (or do the count(*) once and cache it for the
rest of the session).
> I want to be able to in one query get the # of overall rows and do a
> LIMITed resu
Is there some way to take the following 2 queries & make them into one ?
I want to be able to in one query get the # of overall rows and do a LIMITed result
set to get the first NN rows.
Is it possible to to do this in one query ? Presumable MySQL has to figure out what
the overall # is to re