Re: MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

2001-07-18 Thread Dan Nelson
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

MySQL get COUNT(*) on # rows AND return LIMITed results in 1 query ?

2001-07-18 Thread S A
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