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 vote311 views1 answer
Current month transactions in mysql
SQL
8 votes106 views2 answers
Alter column name in mssql
SQL
0 vote155 views1 answer
Querry mysql by 2 columns
SQL
0 vote141 views1 answer
How to define a save method in ruby for sql databases
SQL
6 votes139 views1 answer
Oracle trigger after connect
SQL
0 vote137 views1 answer
Oracle create package body
SQL
0 vote169 views1 answer
Oracle decode
SQL
0 vote145 views1 answer
Luu ckeditor vao mysql
SQL
16 votes142 views1 answer
Mysql mediumint max value
SQL
2 votes159 views3 answers
Row number mysql
SQL