NULL to 0 result
| From: | Ron Piggott | Date: | Tue, 14 Dec 2010 21:53:36 +0000 |
| Subject: | NULL to 0 result | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47540@lists.php.net to get a copy of this message | ||
What change is needed to this query so if “currently_in_rss” is NULL it will be assigned a value
of 0
SELECT
reference, COUNT(reference) AS currently_in_rss FROM
ministry_profiles WHERE rss_feed_include = 1 GROUP BY
rss_feed_include
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info