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

-1 vote270 views1 answer
Su: Authentication failure mysql
SQL
0 vote257 views1 answer
Postgresql array to rows
SQL
0 vote393 views1 answer
Sql insert exemplo
SQL
-1 vote286 views2 answers
Postgres autoincrement primary key
SQL
0 vote320 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote268 views1 answer
Mysql select where field is a value
SQL
2 votes279 views6 answers
Mysql change timezone
SQL
0 vote277 views1 answer
Mariadb select limit offset
SQL
2 votes290 views1 answer
Ifnull postgres
SQL
4 votes274 views2 answers
Convert utc to est sql
SQL