Curriculum
Course: MYSQL
Login

Curriculum

MYSQL

MySQL References

0/140
Text lesson

MySQL Operators

MySQL Arithmetic Operators

Operator

Description

+

Add

Subtract

*

Multiply

/

Divide

%

Modulo

MySQL Bitwise Operators

Operator

Description

&

BitwiseAND

|

Bitwise OR

^

Bitwise exclusive OR

MySQL Comparison Operators

Operator

Description

=

Equal to

Greater than

<

Less than

>=

Greater than or equal to

<=

Less than or equal to

<> 

Not equal to 

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 Logical Operators

Operator

Description

ALL

Returns true if all values from the subquery satisfy the condition.

AND

Returns true if all conditions connected by ‘AND’ are true.

ANY

Returns true if any of the values from the subquery satisfy the condition.

BETWEEN

Returns true if the operand falls within the range of comparisons.

EXISTS

Returns true if the subquery retrieves one or more records.

IN

Returns true if the operand matches any expression from a given list

LIKE

Returns true if the operand conforms to a specified pattern.

NOT

Displays a record if the condition(s) is false.

OR

Returns true if any of the conditions connected by ‘OR’ are true.

SOME

Returns true if any of the values from the subquery satisfy the condition.”