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 vote134 views1 answer
Mysql 8 geo to json
SQL
0 vote80 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
2 votes140 views1 answer
Oracle drop sequence if exists
SQL
2 votes139 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote141 views1 answer
How to change mysql root password in windows 10
SQL
0 vote137 views1 answer
Mysql docker image arjun
SQL
0 vote137 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote131 views1 answer
Sql query contains multiple ids
SQL
19 votes132 views6 answers
What is mySQL
SQL
0 vote145 views2 answers
Sql query print strings and int
SQL