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 vote416 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
22 votes393 views3 answers
How to join three tables in sql using joins
SQL
0 vote368 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote372 views1 answer
Mysql alter decimal precision
SQL
0 vote362 views1 answer
Sql server separar numeros por comas miles
SQL
-1 vote372 views1 answer
Select first rows postgresql
SQL
4 votes387 views1 answer
Ms sql truncate table vs delete
SQL
0 vote379 views1 answer
ORA-13717
SQL
0 vote361 views1 answer
Mysql subdate
SQL
0 vote397 views1 answer
Having all mysql
SQL