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 vote247 views5 answers
Mode sql course
SQL
7 votes242 views2 answers
Execute mysql file
SQL
0 vote236 views1 answer
Mysql changer nom table
SQL
-2 votes230 views1 answer
Create trigger syntax
SQL
6 votes221 views4 answers
Sqlite drop table
SQL
0 vote221 views1 answer
How many columns can be used for creating index?
SQL
0 vote238 views1 answer
Connecting mySQL to STS
SQL
12 votes258 views2 answers
Select into insert sql server
SQL
1 vote246 views1 answer
ORA-01950
SQL
0 vote221 views2 answers
Cascade syntax in sql
SQL