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

2 votes113 views5 answers
Eloquest how to select one specific column in database
SQL
0 vote111 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote115 views1 answer
Add sqlcmd to path linux
SQL
0 vote107 views2 answers
Create new table plsql
SQL
0 vote112 views1 answer
Connect by query in oracle
SQL
0 vote96 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote113 views2 answers
Which MySQL statement is used to delete data from a database
SQL
6 votes100 views2 answers
Mysql execute file
SQL
12 votes111 views1 answer
Docker run mysql image
SQL
2 votes96 views2 answers
Postgresql date at timezone
SQL