List:General Discussion« Previous MessageNext Message »
From:David Perron Date:March 25 2004 11:44pm
Subject:Nested IF statement in 3.23.57
View as plain text  
Are nested IF statements valid?  Doesn't say anything here:
http://www.mysql.com/doc/en/Control_flow_functions.html

Trying to get a conditional count using the following statement - but Im
receiving an error.  I would use a CASE statement but my version 
doesn't support it.

SUM(IF(AdGroups.Status = 'Paused',IF(AdGroupCriteria.Status,Active,1,0),0))

+-------------+
| version()   |
+-------------+
| 3.23.57-Max |
+-------------+





Thread
Nested IF statement in 3.23.57David Perron26 Mar
  • Re: Nested IF statement in 3.23.57Paul DuBois26 Mar