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

150 votes381 views10 answers
Grepper
SQL
-2 votes255 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote241 views1 answer
Sqlite trim
SQL
21 votes225 views4 answers
Add column mssql
SQL
0 vote237 views1 answer
Select into table variable
SQL
0 vote242 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote232 views1 answer
Postgresql comandos basicos
SQL
0 vote221 views2 answers
Update all linkedserver tables with openquery on db
SQL
-1 vote210 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
1 vote217 views1 answer
Postgres cast as currency format
SQL