mysql SELECT IF statement with OR

Question

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

What if you change your condition to compliment IN ('set','Y','1') — Lamak
– Lamak, Commented Feb 2, 2012 at 12:10
You might consider just not doing this in your query. This is formatting, not querying anymore. You get a clear true/false 1/0 in return which should do the trick. For example you could do: if(compliment) etc which cannot be done with a string like Y/N. Also Y/N is language agnostic while the boolean is not. So when translating to dutch for example you would have to convert Y/N again to J/N. In short: Maybe just don't do this unless you have a very good reason to do so or just have to take a cut-off solution. — Luc Franken
– Luc Franken, Commented Feb 2, 2012 at 12:21
Thanks for your feedback i agree boolean would be a better value to use. However im working with existing data and not able to change all the values without further knock on effect on other parts. — Robbo_UK
– Robbo_UK, Commented Feb 2, 2012 at 12:52

Digbyswift · Accepted Answer · 2012-02-02 12:12:00Z

121

Presumably this would work:

IF(compliment = 'set' OR compliment = 'Y' OR compliment = 1, 'Y', 'N') AS customer_compliment

answered Feb 2, 2012 at 12:12

Digbyswift

10.4k4 gold badges41 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Maybe a dumb question, but does an IN clause work here? E.g. IF(compliment IN('set','Y',1), 'Y', 'N') AS customer_compliment?

Community · Accepted Answer · 2017-05-23 11:47:18Z

19

IF(compliment IN('set','Y',1), 'Y', 'N') AS customer_compliment

Will do the job as Buttle Butkus suggested.

CommunityBot

11 silver badge

answered Jul 4, 2016 at 6:47

AleXqwq

2714 silver badges6 bronze badges

This is a good shout for VARCHAR and INT values, but does not work with null. Cross-reference here.