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

1 vote200 views1 answer
Set mysql mode global query
SQL
0 vote196 views1 answer
Ms sql unique
SQL
4 votes199 views2 answers
Oracle unlock user
SQL
0 vote200 views1 answer
My sql data file extention
SQL
0 vote248 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote265 views2 answers
How to take recent row without limit in mysql
SQL
0 vote255 views1 answer
T-sql delete view if exists
SQL
0 vote198 views1 answer
Mysql to get column name in database
SQL
10 votes371 views4 answers
Mysql if else
SQL
11 votes205 views3 answers
How to get last row of table in sql
SQL