In MariaDB, comparison operators are used to compare expressions and return true or false. Here’s how you can use comparison operators in MariaDB:
1. `=` (Equal):
This operator checks if the values of two operands are equal or not. If they are equal, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary = 5000;
1. `<>` or `!=` (Not equal):
This operator checks if the values of two operands are equal or not. If they are not equal, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary != 5000;
1. `<` (Less than):
This operator checks if the value of the left operand is less than the value of the right operand. If it is, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary < 5000;
1. `>` (Greater than):
This operator checks if the value of the left operand is greater than the value of the right operand. If it is, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary > 5000;
1. `<=` (Less than or equal to):
This operator checks if the value of the left operand is less than or equal to the value of the right operand. If it is, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary <= 5000;
1. `>=` (Greater than or equal to):
This operator checks if the value of the left operand is greater than or equal to the value of the right operand. If it is, it returns true. Otherwise, it returns false.
Example:
SELECT \* FROM employees WHERE salary >= 5000;
Remember to replace `employees` and `salary` with your actual table and column names.
