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 vote335 views1 answer
Add column to table with default value plsql
SQL
0 vote327 views1 answer
Mysql select last 15 minutes
SQL
0 vote338 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote327 views1 answer
Oracle job schedules
SQL
0 vote357 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
11 votes378 views1 answer
Oracle export view ddl
SQL
4 votes341 views2 answers
How to insert ip address in mysql using php
SQL
0 vote321 views1 answer
Wordpress sql change site url
SQL
0 vote315 views1 answer
Generate sequence number in sql server
SQL
7 votes365 views2 answers
Mysql check db size
SQL