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

Cast Functions and Operators

Name Description
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
LIKE Simple pattern matching
NOT BETWEEN ... AND ... Whether a value is not within a range of values
NOT LIKE Negation of simple pattern matching

Flow Control Functions

Name Description
CASE Case operator
IF() If/else construct

Logical Operators

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