On 15/12/10 21:42, Richard Quadling wrote:
On 14 December 2010 21:53, Ron Piggott<ron.piggott@xxxxxxxxxxxxxxxxxx> 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/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
