If you are using the result set as part of an application, you could select, then count the rows or use a function such as in PHP : mysql_num_rows()
Jerry ----- Original Message ----- From: "Mojtaba Faridzad" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 1:08 PM Subject: how to limit COUNT(*) > Hi, > > I guess there is no way to limit COUNT(*). Is that right? We cannot use the > result of COUNT in WHERE condition or LIMIT doesn't help. In this case so > far I have retrieved a field and used LIMIT. Is there a better way to > control it? > > Thanks > > > -- > 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]