Fw: COUNT() Efficiency

'Rhino'" <[EMAIL PROTECTED]> Sent: Saturday, April 08, 2006 6:57 PM Subject: RE: COUNT() Efficiency Sorry about the previous empty message. This is the actual query: SELECT messages.id, subject, IF(COUNT(messages.id)=1, CONCAT(members.surname, ', ', members.forename),

Re: COUNT() Efficiency

- Original Message - From: "Martin Gallagher" <[EMAIL PROTECTED]> To: Sent: Saturday, April 08, 2006 6:34 PM Subject: COUNT() Efficiency 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() Efficiency

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 PROT