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

3 votes204 views2 answers
Df to sql pandas sql achemy
SQL
0 vote207 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote196 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
-1 vote206 views1 answer
Module operator in oracle sql
SQL
0 vote198 views1 answer
What does leave do in mysql
SQL
0 vote206 views1 answer
On delete set default
SQL
2 votes233 views1 answer
Coalesce sql
SQL
5 votes201 views1 answer
Sql check if date is between 2 dates
SQL
1 vote209 views1 answer
Sql current timestamp
SQL
0 vote197 views1 answer
Sql change primary key to composite key
SQL