Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but only 1 row is returned from that query always.. I want MySQL to stop the count when it reaches to 200, rather to have it go over all the table and return me 3500..
> SELECT COUNT(*) FROM tbl WHERE where_clause limit 200; > > -----Original Message----- > From: Lorderon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 17, 2004 6:45 PM > To: [EMAIL PROTECTED] > Subject: limit stop count > > > How can I limit a count to stop when he reaches 200 rows? > > SELECT COUNT(*) FROM tbl WHERE where_clause; => returns 3500 > > I want to stop the counting when it reaches to 200, so MySQL will not search > further to count all the 3500 rows.. > > > thanks, > -Lorderon. > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
