Sql where keyword

This article is tagged with: Sql where keyword and mysql

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;

sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
category LIKE '%keyword%'
OR location LIKE '%keyword%'
)

This article is tagged with: Sql where keyword and mysql