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 vote259 views1 answer
Hangfire clear all jobs
SQL
0 vote202 views1 answer
Load utilities in sql server
SQL
0 vote213 views1 answer
Sql query to find duplicate email address
SQL
0 vote207 views2 answers
Postgres show current role
SQL
3 votes197 views2 answers
Plsql print
SQL
0 vote215 views1 answer
Wordpress database query change url
SQL
6 votes196 views5 answers
Get current date sql
SQL
1 vote211 views1 answer
Use of now() in mysql
SQL
2 votes188 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
1 vote192 views1 answer
Adding a default constraint to an existing column in sql
SQL