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 vote209 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
1 vote170 views1 answer
Psql kill pid
SQL
5 votes207 views1 answer
Commentaire table oracle
SQL
0 vote204 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote201 views1 answer
Possgress drop if exists view
SQL
0 vote222 views1 answer
Pgadmin check database
SQL
0 vote200 views1 answer
How to find sql server installation folder
SQL
1 vote209 views2 answers
How to search date in sql query
SQL
1 vote199 views1 answer
Create procedure with encryption
SQL
2 votes225 views2 answers
Spring where to put the data sql
SQL