What are Comparison Operators?
Comparison operators in MariaDB are used to compare values in expressions and return a boolean result (TRUE or FALSE) based on the comparison. These operators allow us to perform various types of comparisons, such as equal to, not equal to, greater than, less than, etc.
Comparison operators are fundamental in SQL queries as they enable you to filter data based on specific conditions, making your queries more selective and powerful. Below are the most widely used Comparison operators in MariaDB to perform various operations and queries.
The following are the comparison operators used in MariaDB:
|
Operators |
Description |
|---|---|
|
`=` |
Selects rows where the specified column is equal to a given value. |
|
`!=` or `<>` |
Excludes rows where the specified column is equal to a given value. |
|
`>` |
Retrieves rows where the specified column is greater than a given value. |
|
`<` |
Retrieves rows where the specified column is less than a given value. |
|
`>=` |
Retrieves rows where the specified column is greater than or equal to a given value. |
|
`<=` |
Retrieves rows where the specified column is less than or equal to a given value. |
|
`IS NULL` |
Retrieves rows where the specified column contains NULL values. |
|
`IS NOT NULL` |
Retrieves rows where the specified column does not contain NULL values. |
|
`LIKE` |
Retrieves rows where the specified column matches a specific pattern. |
|
`NOT LIKE` |
Retrieves rows where the specified column does not match a pattern. |
|
`IN` |
Retrieves rows where the specified column has values present in a given list. |
|
`NOT IN` |
Retrieves rows where the specified column does not have values present in a given list. |
Comparison Operator in MariaDB
In the world of database management, precise comparisons are essential for accurate data retrieval and manipulation. MariaDB, a powerful open–source relational database system, offers a range of comparison operators to help us filter and query our data effectively. In this article, We will learn about what are Comparison operators and How to use them to get efficient output with the help of various examples and so on.