Mega Code Archive

 

Categories / MySQL Tutorial / Introduction

 

Operator precedences

Operator precedences are shown in the following list, from lowest precedence to the highest. Operators that are shown together on a line have the same precedence. := ||, OR, XOR &&, AND NOT BETWEEN, CASE, WHEN, THEN, ELSE =, , =, , , !=, IS, LIKE, REGEXP, IN | & -, + *, /, DIV, %, MOD ^ - (unary minus), ~ (unary bit inversion) ! BINARY, COLLATE