MySQL Operators
MySQL Operators
MySQL operators are keywords and symbols used to perform operations with data values.
MySQL operators are used in SQL statements like SELECT,
WHERE, LIKE, etc.
MySQL operators is categorized into the following types:
- Arithmetic operators
- Comparison operators
- Compound operators
- Bitwise operators
- Logical operators
MySQL Arithmetic Operators
MySQL Comparison Operators
MySQL Compound Operators
| Operator |
Description |
| += |
Add equals |
| -= |
Subtract equals |
| *= |
Multiply equals |
| /= |
Divide equals |
| %= |
Modulo equals |
| &= |
Bitwise AND equals |
| ^-= |
Bitwise exclusive equals |
| |*= |
Bitwise OR equals |
MySQL Bitwise Operators
| Operator |
Description |
| & |
Bitwise AND |
| | |
Bitwise OR |
| ^ |
Bitwise exclusive OR |
MySQL Logical Operators
| Operator |
Description |
Example |
| ALL |
TRUE if all of the subquery values meet the condition |
Try it |
| AND |
TRUE if all the conditions separated by AND is TRUE |
Try it |
| ANY |
TRUE if any of the subquery values meet the condition |
Try it |
| BETWEEN |
TRUE if the operand is within the range of comparisons |
Try it |
| EXISTS |
TRUE if the subquery returns one or more records |
Try it |
| IN |
TRUE if the operand is equal to one of a list of expressions |
Try it |
| LIKE |
TRUE if the operand matches a pattern |
Try it |
| NOT |
Displays a record if the condition(s) is NOT TRUE |
Try it |
| OR |
TRUE if any of the conditions separated by OR is TRUE |
Try it |
| SOME |
TRUE if any of the subquery values meet the condition |
Try it |
