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]