Sorry, taken out of context please ignore my first response. George ----- Original Message ----- From: "George Pitcher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "mos" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 9:46 AM Subject: Re: How to Count(*) with LIMIT
> Can't you use the num_rows funtion to provide the count? > > George > ----- Original Message ----- > From: "mos" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 6:11 AM > Subject: Re: How to Count(*) with LIMIT > > > > I have a Where clause like: > > select count(*) from table where .... LIMIT 100 > > > > Unfortunately the Count(*) ignores the LIMIT clause entirely. Why? > > > > It seems to me that if a "select * from table where ... limit 100" returns > > between 0 and 100 rows, you should be able to count it. Instead the count > > returns 55,000 or some ridiculously large number that has no bearing on > the > > # of rows that will actually be returned (because of the LIMIT clause). > > Since this is running on a webserver, I don't want it to physically count > > more than 100 rows. Some of the tables may be over 1 million rows and > > counting that many rows when only 100 rows are returned is overkill. > > > > Is there a way around this counting problem? The only solution I've come > up > > with is to traverse all the rows returned by counting them in a loop. This > > seems pretty lame and I'm hoping someone can come up with a better > solution. > > > > Mike > > > > sql,query > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php