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 vote308 views1 answer
Laravel migration sql dump
SQL
0 vote307 views1 answer
Get date from timestamp in mysql
SQL
0 vote301 views1 answer
C# mysql update statement set value to null
SQL
1 vote296 views1 answer
Mysql copy table1 to table2
SQL
0 vote297 views2 answers
Sqlite unix timestamp
SQL
1 vote295 views1 answer
Oracle sql listagg
SQL
4 votes286 views1 answer
Restart for pg_hba.conf file
SQL
0 vote309 views1 answer
Mysql cli output to a file
SQL
0 vote315 views1 answer
Procedure excute monthly oracle
SQL
0 vote300 views1 answer
SQL Server Enterprise
SQL