LIKE and BETWEEN are special operators that can be used in a WHERE clause AND and OR are special operators that you can use with WHERE to filter the query on two or more conditions. ORDER BY lets you sort the results of the query in either ascending or descending order. LIMIT lets you ...
The following operators can be used in theWHEREclause: OperatorDescriptionExample =EqualTry it >Greater thanTry it <Less thanTry it >=Greater than or equalTry it <=Less than or equalTry it <>Not equal.Note:In some versions of SQL this operator may be written as !=Try it ...