Operator Overview

Arithmetic operator

Name	Description
%,MOD	Take the rest
*	Multiplication
+	Addition
-	Subtraction
-	minus sign
/	Division
DIV	For integer division

Assignment operator

Name	Description
=	equal operator, used for assignment

Binary Operator

Name	Description
&	bit operator and, bitwise and
>>	Shift the displacement operator right
<<	Distance operator shift left
^	Bitwise XOR
|	bit operator or, bitwise or
~	Unary operator, binary inversion

Cast function and operator

Name	Description
BINARY()	Functions that convert values to binary strings
CAST()	Convert values to specific types for decimal values and character types
CONVERT()	Convert values to specific types for conversion between date and time values and decimals

Comparison functions and operators

Name	Description
>	greater than
>=	greater than or equal to
<	Less than
<>,!=	Not equal
<=	Less than or equal to
=	equals
BETWEEN … AND …	Between two values
IN()	In the collection
IS	Test whether the value is a Boolean value. If it is a Boolean value, it returns “true”
IS NOT	Test whether the value is a boolean value, negative usage of IS
IS NOT NULL	Not empty
IS NULL	empty
ISNULL	Use instead of = to test whether the value is NULL.
LIKE	Fuzzy matching
ILIKE	Fuzzy matching, same as LIKE. But it is not case sensitive.
NOT BETWEEN … AND …	Not between two values
NOT IN	Abbreviation of multiple XOR conditions
NOT LIKE	Fuzzy matching, negative usage of Like
COALESCE	Returns the first non-null value

Control Flow Function

Name	Description
CASE	Case when operator
IF()	If/else statement
IFNULL()	If null/else statement
NULLIF()	NULL is returned when expr1 = expr2, otherwise it returns expr1

Logical operator

Name	Description
AND,&&	Logic and
NOT,!	Logical non
OR	Logical or
XOR	Logical XOR

Last updated on Oct 19, 2026