SQL — Operators

Comparison operators

-- Equal
SELECT * FROM users WHERE age = 25;

-- Not equal
SELECT * FROM users WHERE age != 25;
SELECT * FROM users WHERE age <> 25;

-- Greater than
SELECT * FROM users WHERE age > 25;

-- Less than
SELECT * FROM users WHERE age < 25;

-- Greater than or equal
SELECT * FROM users WHERE age >= 25;

-- Less than or equal
SELECT * FROM users WHERE age <= 25;

BETWEEN

SELECT * FROM users WHERE age BETWEEN 20 AND 30;

IN

SELECT * FROM users WHERE city IN ('NYC', 'LA', 'Chicago');

LIKE

-- Starts with
SELECT * FROM users WHERE name LIKE 'A%';

-- Ends with
SELECT * FROM users WHERE name LIKE '%son';

-- Contains
SELECT * FROM users WHERE name LIKE '%ali%';

-- Single character
SELECT * FROM users WHERE name LIKE '_lice';

IS NULL

SELECT * FROM users WHERE email IS NULL;
SELECT * FROM users WHERE email IS NOT NULL;

Mini Practice

1. Use comparison operators
2. Filter with BETWEEN
3. Use IN operator
4. Pattern match with LIKE

Up Next

Continue with And/Or - Logical operators.