MySQL IF Function: Examples (original) (raw)

#1 SELECT IF(1 = 2,' true','false'); #2 SELECT IF(1 = 1,' true','false'); #3 SELECT customerNumber, customerName, state, country FROM customers; #4 SELECT customerNumber, customerName, IF(state IS NULL, 'N/A', state) state, country FROM customers; #5 SELECT SUM(IF(status = 'Shipped', 1, 0)) AS Shipped, SUM(IF(status = 'Cancelled', 1, 0)) AS Cancelled FROM orders; #6 SELECT DISTINCT status FROM orders ORDER BY status; #7 SELECT COUNT(IF(status = 'Cancelled', 1, NULL)) Cancelled, COUNT(IF(status = 'Disputed', 1, NULL)) Disputed, COUNT(IF(status = 'In Process', 1, NULL)) 'In Process', COUNT(IF(status = 'On Hold', 1, NULL)) 'On Hold', COUNT(IF(status = 'Resolved', 1, NULL)) 'Resolved', COUNT(IF(status = 'Shipped', 1, NULL)) 'Shipped' FROM orders; #8 SELECT status, COUNT(STATUS) FROM orders GROUP BY status