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 vote143 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
1 vote90 views1 answer
Athena query timestamp greater than
SQL
3 votes167 views1 answer
RENAME table pl sql
SQL
3 votes135 views2 answers
Sql asc
SQL
25 votes146 views4 answers
Sqlserver add column
SQL
0 vote140 views1 answer
Jdbc sql connection string
SQL
1 vote124 views1 answer
How to delete data from sql database in android
SQL
1 vote132 views1 answer
Store select query result in variable sql server
SQL
0 vote142 views1 answer
Python mysql query to dataframe
SQL
11 votes139 views1 answer
Sql query to find duplicates in column
SQL