How do you write IF ELSE statement in a MySQL query?
SELECT id, name, email, salary, IF(salary > 20000, 'Good', 'Average') AS type FROM `customers`;
BY Best Interview Question ON 20 Sep 2022
SELECT id, name, email, salary, IF(salary > 20000, 'Good', 'Average') AS type FROM `customers`;