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%'
)

Source: stackoverflow.com

Similar codes

0 vote337 views2 answers
Sql update top 100
SQL
0 vote355 views1 answer
SQL Server rename foreign key constraint
SQL
12 votes348 views6 answers
Between in sql
SQL
0 vote334 views1 answer
Pl sql constraint user function
SQL
0 vote339 views1 answer
Postgres where
SQL
0 vote333 views1 answer
Why mysql is used?
SQL
0 vote315 views1 answer
Get number of table colums in sql query
SQL
11 votes389 views2 answers
Having clause in sql
SQL
0 vote328 views1 answer
Lister les index d'une table oracle
SQL
0 vote373 views3 answers
Condition in count sql
SQL