MySQL WHERE Clause Filtering Examples

Basic Filtering with WHERE Clause

The WHERE clause filters rows by comparing column values to specified criteria.

It is used after the FROM clause in a SELECT statement.

• Syntax: SELECT columns FROM table WHERE condition;
• Conditions use comparison operators like =, <, >, <=, >=, <>.

Using Logical Operators for Multiple Conditions

Logical operators combine multiple conditions in the WHERE clause.

AND requires all conditions to be true, OR requires at least one.

• AND example: WHERE department = 'Sales' AND salary > 50000
• OR example: WHERE department = 'Sales' OR department = 'Marketing'

Filtering with Range and Set Operators

MySQL supports filtering rows within ranges or sets using BETWEEN and IN operators.

• BETWEEN selects values within a range, inclusive.
• IN selects values matching any in a list.

Pattern Matching with LIKE Operator

The LIKE operator filters text columns using patterns with wildcards.

The percent sign (%) matches zero or more characters, underscore (_) matches a single character.

• Example: WHERE name LIKE 'A%' finds names starting with 'A'.
• Example: WHERE email LIKE '%@gmail.com' finds emails ending with '@gmail.com'.