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 |