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

7 votes341 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote328 views1 answer
Get sum sqlite android
SQL
13 votes298 views3 answers
Uninstall mysql centos 7
SQL
0 vote322 views1 answer
Get number of rows in every table mysql
SQL
1 vote319 views1 answer
Pl sql ptint
SQL
1 vote317 views2 answers
Sql multiline comment
SQL
1 vote333 views1 answer
Retrieve meaning
SQL
0 vote332 views1 answer
Sql join on a subquery
SQL
0 vote308 views1 answer
Select value from previous row in postgresql
SQL
0 vote317 views1 answer
Test connection to sql server
SQL