SQL COUNT(condition)?

[rossco_2005]

Hi,

I have two queries:

SELECT COUNT(*) AS comments
FROM ng_comment
WHERE ng_comment.collectionid = 47

SELECT COUNT(*) AS comments2
FROM ng_comment
WHERE ng_comment.collectionid = 47
AND ng_comment.dateline <= 1262487011

Is there a way that I can combine these?
I was thinking something like:

SELECT COUNT(*) AS comments, COUNT(IF ng_comment.dateline <= 1262487011) AS comments2
FROM ng_comment
WHERE ng_comment.collectionid = 47

But I'm not sure what the syntax for this is in MySQL.

Any help? Thanks.

PS. I also posted this on vbulletin.com, but I think this forum is a bit busier than the programming discussion on vbulletin.com. (http://www.vbulletin.com/forum/showt...28condition%29)

--------------- Added [DATE]1263058583[/DATE] at [TIME]1263058583[/TIME] ---------------

I figured it out for myself.
I used:

SELECT COUNT(*) AS totalcomments, COUNT(CASE WHEN ng_comment.dateline <= 1262487011 THEN 1 ELSE null END) AS newercomments
FROM ng_comment
WHERE ng_comment.collectionid = 47