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

2 votes177 views2 answers
Sql strip non alphanumeric characters
SQL
4 votes260 views4 answers
Update select mysql
SQL
16 votes178 views4 answers
Mysql import from sql file
SQL
1 vote170 views1 answer
Apex ORA-20999
SQL
1 vote164 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes175 views1 answer
Mysql set field unique
SQL
1 vote170 views1 answer
Table information in sql server
SQL
-1 vote183 views2 answers
Postgresql get last 10 records
SQL
1 vote176 views1 answer
Oracle stop job
SQL
24 votes174 views5 answers
Sql server insert into select
SQL