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 vote335 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote330 views1 answer
Oracle NLS_CHARACTERSET
SQL
12 votes339 views6 answers
Distinct in sql server
SQL
0 vote304 views2 answers
Transaction php
SQL
24 votes324 views6 answers
Replace mysql
SQL
0 vote324 views1 answer
T sql dynamic top n query
SQL
0 vote319 views1 answer
Sql put two columns into one
SQL
0 vote306 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote313 views1 answer
Create a table from one field of another table
SQL
5 votes295 views1 answer
Oracle get nls settings
SQL