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 vote158 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote178 views1 answer
Mysql group by range
SQL
0 vote174 views1 answer
Default value false mysql
SQL
12 votes158 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote191 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote162 views4 answers
First max salary in sql
SQL
4 votes185 views2 answers
Delete all table oracle
SQL
0 vote208 views1 answer
ALV GRID events
SQL
1 vote160 views1 answer
Sql trigger before delete
SQL
1 vote225 views1 answer
Mysql sort by date column
SQL