I want to use CASE WHEN statement for this purpose, however, THEN seems not recognized (not in blue like CASE but in black) and I got error 1064. In this dashboard I want to compare two total througheed time(average time of each process added together for product Seiten & Boden) and only show the longer one as final throughfeed time. The CASE statement goes through conditions and return a value when the first condition is met (like an IF-THEN-ELSE statement). Switch statement selects one of many blocks. CASE Avalue WHEN Bvalue THEN Bstatement WHEN CValue THEN Cstatement. SELECT OrderID, Quantity, 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 Try it Yourself The following SQL will order the customers by City. I have a Grafana + MariaDB setup to get the total throughfeed time in a factory. Switch is another type of conditional, best used in place of a long if-elseif-else conditional. MySQL Query Comparing with value, Syntax is here.

Mysql case select