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 vote167 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
8 votes176 views1 answer
Racle create auto increment column
SQL
10 votes177 views2 answers
Reset mysql root password mac
SQL
0 vote153 views1 answer
Get last updated row sql server
SQL
0 vote139 views1 answer
Asp.net core sql server stored procedure
SQL
15 votes143 views2 answers
Open postgress in terminal mac
SQL
-2 votes145 views1 answer
Create trigger syntax
SQL
2 votes147 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote145 views1 answer
Neo4j command to run script file
SQL
2 votes128 views1 answer
Oracle sql drop table purge
SQL