The operators in MySQL

Arithmetic operators, comparison operators, logical operators, bitwise operators

1. Arithmetic Operators

The arithmetic operators supported by MySQL include subtraction and modulo operations.

Note: 0 cannot be removed; modulo: 3%2 and mod (3,2) effect.

2. comparison Operators

<=> and = similar, the operands have an equal value of 1, but the difference is that even if the values of the operations are null, they can be compared correctly.

The REGEXP operator is used in the format: "Str REGEXP str_pat", when the str string contains a string that matches Str_pat, the return value is 1.

3. logical Operators

A logical operator, also known as a Boolean operator, is used to confirm the authenticity of an expression.

And or &&: When all operands are not 0 values and are not NULL, the result is 1;

OR OR | | : When two operands are non-null values, if any one operand is a non-0 value, the result is 1, otherwise 0;

XOR: The return value is null when either operand is null. For non-null operands, if the logical false value of two is different, return 1, otherwise return 0.

4. Bitwise Operators

Bitwise operation when the given operand into a binary, each operand of each bit of the specified logical operation, the resulting binary result is converted to decimal is the result of the bit operation.

Precedence of Operators

The operators in MySQL