Re: NULL to 0 result

From:	Chris	Date:	Wed, 15 Dec 2010 21:30:04 +0000
Subject:	Re: NULL to 0 result
References:	1 2	Groups:	php.db
Request:	Send a blank email to php-db+get-47543@lists.php.net to get a copy of this message

On 15/12/10 21:42, Richard Quadling wrote:

On 14 December 2010 21:53, 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 ministry_profiles WHERE rss_feed_include = 1 GROUP BY rss_feed_include Ron
Doesn't that query give you an error saying that reference isn't in the GROUP BY clause?

Nah mysql lets you do it. Other db's enforce it as you pointed out. -- Postgresql & php tutorials http://www.designmagick.com/