Re: NULL to 0 result
| From: | Bastien Koert | Date: | Tue, 14 Dec 2010 22:06:41 +0000 |
| Subject: | Re: NULL to 0 result | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47541@lists.php.net to get a copy of this message | ||
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott
<ron.piggott@actsministries.org> wrote:
>
> 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 Eylj
> \ghministry_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
>
SELECT reference, ifnull(COUNT(reference),0) AS currently_in_rss
FROM ministry_profiles WHERE rss_feed_include = 1 GROUP BY
rss_feed_include
--
Bastien
Cat, the other other white meat