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 vote271 views1 answer
Top frequency in sql server
SQL
9 votes289 views3 answers
Date format in sql
SQL
0 vote335 views1 answer
What is common table expression in sql
SQL
0 vote251 views1 answer
Oracle archivemode
SQL
0 vote258 views1 answer
Sql find leading space
SQL
-1 vote260 views1 answer
Sql add column bit
SQL
4 votes275 views2 answers
Oracle last day of month
SQL
0 vote268 views2 answers
Wordpress change url in database
SQL
1 vote251 views1 answer
Display total number of tables in mysql
SQL
1 vote293 views1 answer
Set id count mysql
SQL