mysql SELECT IF statement with OR March 10, 2023 by Tarik Presumably this would work: IF(compliment="set" OR compliment="Y" OR compliment = 1, 'Y', 'N') AS customer_compliment