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 vote376 views1 answer
T sql dynamic top n query
SQL
0 vote371 views1 answer
With_for_update sqlalchemy
SQL
8 votes358 views1 answer
Mac restore mysql database command line
SQL
0 vote382 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote304 views2 answers
Jupyter notebook connect to database
SQL
7 votes419 views3 answers
Sql server check if temp table exists
SQL
35 votes429 views5 answers
Sql alter column
SQL
2 votes381 views4 answers
Check timezone of mysql database
SQL
0 vote393 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote364 views1 answer
Max mysql
SQL