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 vote196 views1 answer
How to query without duplicate rows in sql
SQL
0 vote338 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
5 votes282 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
1 vote525 views1 answer
Mysql event last execution
SQL
0 vote199 views1 answer
Oracle create job if not exists
SQL
4 votes334 views2 answers
Sql display today's date
SQL
0 vote202 views1 answer
Python mysql query to dataframe
SQL
8 votes226 views4 answers
Reset SQL auto increment
SQL
-2 votes199 views2 answers
Sqlserver docker
SQL
0 vote296 views1 answer
Add user mysql wordpress
SQL