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 vote150 views1 answer
Sql tablo hangi sp de
SQL
0 vote145 views1 answer
Google sheets filter rows above current cell
SQL
5 votes138 views2 answers
Postgre insert select
SQL
0 vote143 views1 answer
Add column not null with default value postgres
SQL
6 votes137 views2 answers
Find mysql version linux
SQL
9 votes156 views1 answer
Identity insert on sql server
SQL
12 votes154 views4 answers
Psql command not found
SQL
0 vote152 views1 answer
Sqlite3 update select
SQL
1 vote136 views1 answer
How refresh navicat tables to see new tables
SQL
1 vote173 views1 answer
Sqlalchemy on delete set null
SQL