The following works - returns Y when chargeback equal to 1 else it defaults to N <pre class="prettyprint"><code>IF(fd.charge_back = 1, 'Y', 'N') AS charge_back </code></pre> however I cannot seem to get this one working? Is the syntax valid <pre class="prettyprint"><code>IF(compliment = ('set' OR 'Y' OR 1), 'Y', 'N') AS customer_compliment </code></pre>

Presumably this would work: <pre class="prettyprint"><code>IF(compliment = 'set' OR compliment = 'Y' OR compliment = 1, 'Y', 'N') AS customer_compliment </code></pre>

<pre class="prettyprint"><code>IF(compliment IN('set','Y',1), 'Y', 'N') AS customer_compliment </code></pre> Will do the job as Buttle Butkus suggested.

mysql SELECT IF statement with OR

Tags:

sql

select

mysql

if-statement

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

asked Feb 02 '12 12:02

Robbo_UK

2 Answers

Presumably this would work:

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

176

answered Oct 14 '22 11:10

Digbyswift

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

Will do the job as Buttle Butkus suggested.

answered Oct 14 '22 09:10

AleXqwq

Related questions
                            
                                Equivalent of explode() to work with strings in MySQL
                            
                                Disabling foreign key checks on the command line
                            
                                phpmyadmin.pma_table_uiprefs doesn't exist
                            
                                What MySQL drivers are available for node.js? [closed]
                            
                                MySQL - Selecting a Column not in Group By
                            
                                connecting to a docker-compose mysql container denies access but docker running same image does not
                            
                                How to regex in a MySQL query
                            
                                org.hibernate.AssertionFailure: null id in entry (don't flush the Session after an exception occurs)
                            
                                Should I use blob or text for JSON in MySQL?
                            
                                How can we differ LEFT OUTER JOIN vs Left Join [duplicate]
                            
                                How do I alter a mysql table column defaults?
                            
                                Get only the date in timestamp in mysql
                            
                                Create table variable in MySQL
                            
                                Object of class DateTime could not be converted to string
                            
                                Using Mysqli bind_param with date and time columns?
                            
                                How can I undo a mysql statement that I just executed?
                            
                                How to display UTF-8 characters in phpMyAdmin?
                            
                                Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user 'root'@'localhost'(using password:YES)
                            
                                LINQ to SQL multiple tables left outer join
                            
                                MySQL unknown column in ON clause