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

2 votes228 views1 answer
Get the mysql table columns data type mysql
SQL
10 votes197 views6 answers
Between sql
SQL
0 vote185 views1 answer
Mssql current date
SQL
1 vote209 views1 answer
Mysql datetime with timezone offset
SQL
0 vote197 views1 answer
Exectuer myssql .sql
SQL
1 vote148 views1 answer
Unique vs distinct sql
SQL
1 vote181 views1 answer
Truncate table in postgresql and reset id
SQL
4 votes191 views1 answer
List tables sqlite
SQL
0 vote198 views1 answer
Import sql dump into postgresql database
SQL
1 vote204 views1 answer
Flask sqlalchemy default value
SQL