Hi, If I did a query like:
SELECT COUNT(id) AS count1, COUNT(id) AS count2 FROM table WHERE id<100 Would MySQL run the COUNT() calculation once or twice? Cheers -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]