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 vote271 views1 answer
Sqlalchemy query return only n results
SQL
0 vote245 views1 answer
Select all domains of database firbird
SQL
2 votes273 views3 answers
Mysql list tables by size
SQL
0 vote273 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote293 views1 answer
Renommer base sql
SQL
3 votes267 views3 answers
Into in sql
SQL
0 vote292 views1 answer
Sql common columns
SQL
0 vote281 views1 answer
Less than and between in sql query
SQL
0 vote313 views2 answers
Impala rename column name
SQL
0 vote280 views1 answer
ORACLE PARSE STRING
SQL