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 vote261 views2 answers
How to search date in sql query
SQL
0 vote261 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL
-2 votes264 views1 answer
No module named '_sqlite3
SQL
0 vote218 views1 answer
'0000-00-00' for column '
SQL
8 votes261 views2 answers
How to fetch data from database without last column
SQL
0 vote232 views1 answer
Hallo
SQL
0 vote239 views1 answer
Update top 100 sql
SQL
58 votes508 views6 answers
Create new user in postgres
SQL
0 vote253 views2 answers
Auto increment column in mysql query results
SQL
0 vote273 views1 answer
Kill slow queries mysql
SQL