Understanding the SQL WHERE Clause: Basics and Examples

Introduction

In this article we break down the fundamentals of the SQL WHERE clause, a powerful tool for filtering query results. By the end you’ll be able to write simple and complex conditions without needing to watch the original video.

Simple Equality and Inequality

• Equality: WHERE first_name = 'Jim' returns rows where the first name is exactly Jim.
• Inequality: WHERE first_name <> 'Jim' (or !=) returns every row except those where the first name is Jim.

Comparison Operators (Numeric Data)

• Greater than: WHERE age > 30 selects people older than 30.
• Greater than or equal: WHERE age >= 30 includes 30‑year‑olds.
• Less than: WHERE age < 32 selects people younger than 32.
• Less than or equal: WHERE age <= 32 includes 32‑year‑olds.

Combining Conditions

• AND: All conditions must be true. sql WHERE age <= 32 AND gender = 'Male' Returns only male rows whose age is 32 or less.
• OR: At least one condition must be true. sql WHERE age <= 32 OR gender = 'Male' Includes anyone under 32 or anyone male, so a 35‑year‑old male appears in the result.

Pattern Matching with LIKE

• % is a wildcard representing any sequence of characters.
• Starts with: WHERE last_name LIKE 'S%' finds last names beginning with S (e.g., Schrute, Scott).
• Contains: WHERE last_name LIKE '%S%' finds any last name that contains S anywhere.
• Multiple patterns: Combine conditions for more specific searches. sql WHERE last_name LIKE 'S%' AND last_name LIKE '%O%' Returns names that start with S and contain an O (e.g., Scott).
• Patterns can be chained to mimic complex string checks.

Checking for NULL Values

• WHERE first_name IS NULL returns rows where the column has no value.
• WHERE first_name IS NOT NULL returns all rows where the column contains a value.
• In the demo dataset no first_name values were NULL, so IS NOT NULL returned the whole table.

Using IN for Multiple Equality Checks

• IN provides a concise way to test a column against several values. sql WHERE first_name IN ('Jim', 'Michael') Equivalent to first_name = 'Jim' OR first_name = 'Michael' but much shorter and easier to read.

Summary of Key Operators

• = , <> (or !=) – equality / inequality
• >, >=, <, <= – numeric comparisons
• AND, OR – logical combination
• LIKE with % – pattern matching for text
• IS NULL, IS NOT NULL – null checks
• IN – multiple value matching

Next Steps

After mastering these basics you can move on to more advanced clauses such as GROUP BY and ORDER BY, which will be covered in the next tutorial.

Mastering the WHERE clause lets you precisely filter data using equality, inequality, range checks, logical operators, pattern matching, null handling, and the IN list—forming the foundation for all advanced SQL queries.