On 14 December 2010 21:53, Ron Piggott 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
> `ministry_profiles` WHERE `rss_feed_include` = 1 GROUP BY `rss_feed_incl
On 15/12/10 21:42, Richard Quadling wrote:
On 14 December 2010 21:53, Ron Piggott 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
`ministry_profiles` WHERE `rss_feed_