Select where
Where offer in case:
Operator combining AND and OR
Operator Compare:<>,<=,>=,<,>.!>,!<,!=
Checking limited data: BETWEEN and NOT BETWEEN
IN, NOT IN
Checking the shape of data: LIKE
Value: NULL or IS NOT NULL
Operator combining AND and OR
AND: Select from table_name WHERE Column name one operator value AND Column name two operator value
OR: Select from table_name WHERE Column name one operator value AND Column name two operator value
Condition AND, OR:Select * from table name where column name value operator AND ( column= value OR column=value)
Checking limited data: BETWEEN and NOT BETWEEN
Select *from <Name table > Where<Column > BETWEEN<Min value> AND<MAX >
Checking the shape of data: LIKE
select *from<Name table>where<Column name >like<%value%>: No matter what comes before or after the search character, the % sign doesn't care.
IN, NOT IN :
Specifies multiple values in the WHERE clause
SELECT column_name(s)
.FROM table_name
WHERE column_name IN (value1,value2,...);