MYSQL Tutorial

MySQL Comparison Operators – Compare Values Like a Pro

Comparison operators in MySQL help you compare two values in WHERE clauses or conditions. They return TRUE or FALSE, letting you filter data precisely.

🔹 Common Comparison Operators

🔹 Examples Using Comparison Operators

1. Find employees hired before 2020:

SELECT * FROM employees
WHERE hire_date < '2020-01-01';
  

2. Find employees with salary between 50,000 and 60,000:

SELECT * FROM employees
WHERE salary BETWEEN 50000 AND 60000;
  

3. Find employees whose first name starts with 'J':

SELECT * FROM employees
WHERE first_name LIKE 'J%';
  

4. Find employees in Sales or IT departments:

SELECT * FROM employees
WHERE department IN ('Sales', 'IT');
  

🔹 Interactive Challenge

Write a query to find employees with salary > 55,000 and hired after 2019-01-01.

SELECT * FROM employees
WHERE salary > 55000 AND hire_date > '2019-01-01';
    

🔹 Summary

• = and <> / != for equal and not equal.
• <, <=, >, >= for numeric or date comparisons.
• BETWEEN ... AND ... for ranges.
• LIKE for pattern matching with wildcards.
• IN to check if a value matches any value in a list.