Advertisement

List column comparison operators available in MySQL?

Comparison operators are used in the WHERE clause to select records conditionally.Below are the list of comparison operators supported by MySQL.
  • = Equal
  • <=> Equal (Safe to compare NULL values)
  • <> Not Equal
  • != Not Equal
  • > Greater Than
  • >= Greater Than or Equal
  • < Less Than
  • <= Less Than or Equal
  • IN ( ) Matches a value in a list
  • NOT Negates a condition
  • BETWEEN Within a range (inclusive)
  • IS NULL NULL value
  • IS NOT NULL Non-NULL value
  • LIKE Pattern matching with % and _
  • EXISTS Condition is met if subquery returns at least one row

0 comments

Advertisement