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 vote187 views1 answer
Phinehas Psalm 106
SQL
3 votes188 views1 answer
Convert sqlite table to pandas dataframe
SQL
12 votes199 views1 answer
Run mysql instance in docker
SQL
3 votes189 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
1 vote184 views1 answer
Mysql how to reset primary key
SQL
1 vote178 views1 answer
Oracle difference between two dates in years
SQL
3 votes215 views1 answer
RENAME table pl sql
SQL
0 vote184 views1 answer
Hibernate with springboot mysql
SQL
16 votes184 views3 answers
Jwt secret key generator laravel
SQL
1 vote176 views1 answer
Mysql current time
SQL