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

2 votes116 views2 answers
Sql percentage
SQL
5 votes109 views1 answer
Oracle asynchronous procedure
SQL
0 vote121 views1 answer
How to find sql server installation folder
SQL
0 vote102 views1 answer
Order by monthly in sql
SQL
0 vote142 views1 answer
Pl sql join 3 tables
SQL
0 vote117 views1 answer
Connect to ssms with python
SQL
3 votes116 views5 answers
Mysql get last inserted id
SQL
18 votes115 views3 answers
Mysql query add column with default string value
SQL
0 vote121 views1 answer
Change filed order in mysql
SQL
0 vote116 views1 answer
Sql getdate minus 1 day without time
SQL