In the list here:
https://mariadb.com/kb/en/operator-precedence/
case-expressions are put at the same precedence level as BETWEEN, between the NOT operator and the comparison operators.
However, case-expressions always begin with CASE and end with END, and all subexpressions are also delimited by the CASE keywords. They’re like parenthetical expressions, so I don’t understand why case-expressions are on this list.
Is there an SQL expression that would be parsed differently if the case-expression precedence was set higher or lower?
Go to Source
Author: JoL