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

19 votes200 views5 answers
Mysql between date range
SQL
0 vote144 views1 answer
Mariadb hours between two dates
SQL
0 vote155 views1 answer
Copy from one table to another postgres using matching column
SQL
1 vote118 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
2 votes122 views2 answers
Insert all in sql
SQL
0 vote132 views1 answer
Alter fedora mysql 8.0 user
SQL
3 votes131 views1 answer
Where id is in list sql
SQL
0 vote129 views1 answer
Mysql root localhost run
SQL
2 votes130 views1 answer
Docker run postgres locally
SQL
0 vote72 views1 answer
Mssql view column data type
SQL