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

1 vote163 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote166 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote174 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
1 vote167 views2 answers
Sql left characters
SQL
0 vote178 views1 answer
Str_to_date sql server
SQL
1 vote170 views1 answer
Stop mysql server mac
SQL
2 votes186 views1 answer
Power query concatenate
SQL
0 vote190 views1 answer
Mysql update from select on same table
SQL
57 votes277 views6 answers
Sql alter table
SQL
27 votes181 views6 answers
Sql update record
SQL