Filtering Data with WHERE

The WHERE clause filters rows based on a condition.

Syntax

SELECT columns FROM table_name
WHERE condition;

Operator

Meaning

Equal to

>	Greater than

Less than

>=	Greater than or equal

<=	Less than or equal

<> or !=

Not equal

Select all products where the category is 'Electronics'.