SQL

sql where keyword

Filters results to only include data which meets the given condition.
Example: Returns orders with a quantity of more than 1 item.
SELECT * FROM orders
WHERE quantity > 1;

WHERE keyword SQL

-- The WHERE keyword allows you to filter based on both text and numeric values in a table. 

-- There are a few different comparison operators you can use:
-- = equal
-- <> not equal
-- < less than
-- > greater than
-- <= less than or equal to
-- >= greater than or equal to

SELECT example_column
FROM example_table
WHERE example_column = 'example_value';