Skip to content
Learning

MySQL Operators

In MySQL, operators are used to perform operations on data in queries. These operations can be applied to columns, values, or results of expressions. MySQL provides various types of operators, including arithmetic operators, comparison operators, logical operators, bitwise operators, and more. Below is an overview of the different types of MySQL operators.

Arithmetic Operators

Arithmetic operators are used to perform basic mathematical operations such as addition, subtraction, multiplication, and division.

  • + -> Add
  • - -> Subtract
  • * -> Multiply
  • / -> Divide
  • % -> Modulo

Bitwise Operators

  • & -> Bitwise AND
  • | -> Bitwise OR
  • ^ -> Bitwise exclusive OR

Comparison Operators

  • = -> Equal to
  • > -> Greater than
  • < -> Less than
  • >= -> Greater than or equal to
  • <= -> Less than or equal to
  • <> -> Not equal to

Compound Operators

  • += -> Add equals
  • -= -> Subtract equals
  • *= -> Multiply equals
  • /= -> Divide equals
  • %= -> Modulo equals
  • &= -> Bitwise AND equals
  • ^-= -> Bitwise exclusive equals
  • |*= -> Bitwise OR equals

Logical Operators

  • ALL -> TRUE if all of the subquery values meet the condition
  • AND -> TRUE if all the conditions separated by AND is TRUE
  • ANY -> TRUE if any of the subquery values meet the condition
  • BETWEEN -> TRUE if the operand is within the range of comparisons
  • EXISTS -> TRUE if the subquery returns one or more records
  • IN -> TRUE if the operand is equal to one of a list of expressions
  • LIKE -> TRUE if the operand matches a pattern
  • NOT -> Displays a record if the condition(s) is NOT TRUE
  • OR -> TRUE if any of the conditions separated by OR is TRUE
  • SOME -> TRUE if any of the subquery values meet the condition