There are several operators in mysql.

There are four types of operators in mysql, which are:

arithmetic operator

comparison operator

Logical operator

positional operator

arithmetic operator

Arithmetic operator is the most basic operation operator in SQL, which mainly includes the following operators:

+(addition),-(subtraction), * (multiplication),/(division),% (remainder or modulus)

comparison operator

The result of the comparison operator is always 1, 0 or NULL. Comparison operators in MySQL are:

= 、& lt= & gt、& lt& gt(! =),<=,>=,>, empty, not empty, minimum, maximum and in between. . . And ... . . 、ISNULL、IN、NOT IN、LIKE、REGEXP

Logical operator

The evaluation results of logical operators are all true, false or empty.

Logical operators are:

Not or!

AND or&; & amp

Or or ||

XOR (exclusive OR)

Position operator

Bit operators are used to test, shift or check bits in binary bytes. Bit operators are:

Bit OR (|)

Bit and (&; )

Bitwise XOR ()

Move to the left (

Shift to the right (

Bit inversion (~)