You have two rows the zero which has a single row and the other row If the answer you are after is 48.
select sum(ct_ct_comment_agent) from (SELECT comment_approved, COUNT(comment_agent) as ct_comment_agent from wp_comments WHERE comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by comment_approved )as a On Monday 21 January 2008 6:07:46 pm Mário Gamito wrote: > Hi, > > I'm trying to get a single number out of a SELECT statement: > > SELECT comment_approved, COUNT(comment_agent) from wp_comments WHERE > comment_agent LIKE '%Linux%' OR comment_approved=0 GROUP by > comment_approved > > But instead i get two rows: > |------------------------------------------ > |comment_approved | COUNT (comment_agent) | > |------------------------------------------ > |0 | 1 | > |------------------------------------------ > |1 | 47 | > |-----------------------------------------| > > I've Google about it but found no answer (my bad, probably). > > What I want is to have just 47 as a result of the SELECT. > > Any help would be appreciated. > > Warm regards, > Mário Gamito -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
