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

4 votes331 views1 answer
Describe table mysql
SQL
0 vote314 views2 answers
Php convert dbf to mysql
SQL
1 vote332 views2 answers
Sql now - 1 day
SQL
10 votes307 views2 answers
Mysql select timestamp group by day
SQL
0 vote359 views1 answer
Amount of entries in a table psql
SQL
0 vote298 views1 answer
SQL server select to get sum of hours
SQL
0 vote352 views1 answer
Postgresql port 5432 not open
SQL
1 vote318 views1 answer
Show table columns
SQL
1 vote362 views1 answer
Update foreign key value in mysql
SQL
0 vote343 views1 answer
Import sql in postgresql
SQL