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 vote115 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote128 views1 answer
Oracle swap partition
SQL
0 vote120 views1 answer
Delete * from where id = 1;
SQL
0 vote164 views1 answer
Psql create usr
SQL
0 vote111 views1 answer
Call procedure in wordpress
SQL
0 vote148 views1 answer
What is default mysql database password in linux
SQL
3 votes131 views1 answer
Sql insert inserted id
SQL
1 vote130 views1 answer
Float precision in psql
SQL
0 vote131 views1 answer
Sql server isnull function nor working count
SQL
0 vote136 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL