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 vote229 views1 answer
Isnull in sqlite
SQL
1 vote207 views1 answer
Funzioni plsql
SQL
9 votes202 views3 answers
Mysql get last id
SQL
1 vote220 views1 answer
T-sql find object by name
SQL
3 votes229 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote205 views1 answer
Create index concurrently postgres
SQL
0 vote213 views1 answer
Optimize sql query
SQL
1 vote214 views1 answer
Sql server read uncommitted
SQL
0 vote223 views1 answer
Join creating duplicate columns sqllite
SQL
26 votes165 views10 answers
Insert in to table sql
SQL