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 vote199 views1 answer
Postgresql append array
SQL
0 vote176 views1 answer
Sql max of two values
SQL
0 vote196 views1 answer
Oracle current date minus 1 day
SQL
5 votes146 views4 answers
Describe table postgres
SQL
0 vote153 views1 answer
Change date format in oracle query
SQL
0 vote153 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
6 votes193 views2 answers
Subtr Oracle ?
SQL
15 votes158 views4 answers
Create table if not exists sql
SQL
0 vote158 views1 answer
Excel export from sql using python
SQL
0 vote131 views2 answers
Android sqlite query join
SQL