Skip to content

Operators Overview

Arithmetic Operators

Name Description
%,MOD Modulo operator
* Multiplication operator
+ Addition operator
- Minus operator
- Change the sign of the argument
/ Division operator
DIV Integer division

Assignment Operators

Name Description
= Equal operator

Bit Functions and Operators

Name Description
& Bitwise AND
>> Right shift
<< Left shift
^ Bitwise XOR
| Bitwise OR
~ Bitwise inversion

Cast Functions and Operators

Name Description
BINARY() Convert a value to a binary string
CAST() Cast a value as a certain type
CONVERT() Cast a value as a certain type

Comparison Functions and Operators

Name Description
> Greater than operator
>= Greater than or equal operator
< Less than operator
<>,!= Not equal operator
<= Less than or equal operator
= Equal operator
BETWEEN ... AND ... Whether a value is within a range of values
IN() Whether a value is within a set of values
IS Test a value against a boolean
IS NOT Test a value against a boolean
IS NOT NULL NOT NULL value test
IS NULL NULL value test
ISNULL instead of = to test whether a value is NULL
LIKE Simple pattern matching
ILIKE Simple pattern matching. Same as LIKE. But it is not case sensitive.
NOT BETWEEN ... AND ... Whether a value is not within a range of values
NOT IN shorthand for multiple XOR conditions
NOT LIKE Negation of simple pattern matching
COALESCE Return the first non-null value in a list

Flow Control Functions

Name Description
CASE Case operator
IF() If/else construct
IFNULL() Null if/else construct
NULLIF() Return NULL if expr1 = expr2

Logical Operators

Name Description
AND,&& Logical AND
NOT,! Negates value
OR Logical OR
XOR Logical XOR