mysql SQL CASE January 1, 2019 Manisha Patel case example in mysql, CASE WHEN Quantity > 30 THEN "The quantity is greater than 30" WHEN Quantity = 30 THEN "The quantity is 30" ELSE "The quantity is under 30" END AS QuantityText FROM OrderDetails;, MySQL, mysql case statement, Quantity, SELECT OrderID, SQL CASESQL CASE The CASE statement goes through conditions and return a value when the first condition is met (like an Read more