Menu
The following works - returns Y when chargeback equal to 1 else it defaults to N
IF(fd.charge_back = 1, 'Y', 'N') AS charge_back however I cannot seem to get this one working? Is the syntax valid
IF(compliment = ('set' OR 'Y' OR 1), 'Y', 'N') AS customer_compliment 
619
The && , operator is a nonstandard MySQL extension. As of MySQL 8.0. 17, this operator is deprecated; expect support for it to be removed in a future version of MySQL. Applications should be adjusted to use the standard SQL AND operator.
Answer: MySQL IF() function can be used within a query, while the IF-ELSE conditional statement construct is supported to be used through FUNCTIONS or STORED PROCEDURES.
Presumably this would work:
IF(compliment = 'set' OR compliment = 'Y' OR compliment = 1, 'Y', 'N') AS customer_compliment 
IF(compliment IN('set','Y',1), 'Y', 'N') AS customer_compliment Will do the job as Buttle Butkus suggested.
27
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
