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
No comments:
Post a Comment