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 vote211 views1 answer
Apex for oracle 11g
SQL
4 votes248 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote326 views1 answer
Adding a check statement in sql
SQL
1 vote201 views1 answer
Create email address from first and last name in sql
SQL
41 votes302 views6 answers
Alter table add column in SQL Server
SQL
1 vote237 views1 answer
Find difference in dates sql
SQL
0 vote200 views1 answer
Convert rows to columns in sql server
SQL
4 votes198 views1 answer
Oracle session date format
SQL
2 votes365 views1 answer
How to create sql database
SQL
0 vote221 views1 answer
Str_to_date sql server
SQL