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 votes290 views1 answer
Mysql create user with mysql_native_password
SQL
0 vote277 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote271 views1 answer
Django mysqlclient connection string
SQL
0 vote302 views1 answer
How to define a non primary composite key in sql
SQL
0 vote281 views1 answer
Mysql procedure between two tables
SQL
0 vote269 views1 answer
T-sql conditional order by multiple columns
SQL
0 vote285 views1 answer
Mysql preg replace
SQL
1 vote307 views2 answers
Maximum number of tables in mysql
SQL
0 vote282 views1 answer
How to access to mysql without root
SQL
5 votes281 views1 answer
How to use rank function in sql
SQL