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 vote309 views2 answers
How to update date in oracle
SQL
20 votes299 views5 answers
Mysql reset auto increment to 1
SQL
0 vote313 views1 answer
Mysql search multiple tables
SQL
0 vote315 views1 answer
Monthly Birthday SQL Query
SQL
4 votes319 views2 answers
Oracle unlock user
SQL
1 vote312 views2 answers
Mysql: command not found
SQL
0 vote313 views1 answer
How to select even id in sql
SQL
7 votes346 views1 answer
Mysql remote connection command line
SQL
0 vote330 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
2 votes343 views3 answers
Row number mysql
SQL