MySQL where condition

MySQL where condition

 

WHERE Syntax

SELECT column1, column2, …
FROM table_name
WHERE condition;

Note: The WHERE clause is not only used in SELECT statement, it is also used in UPDATE, DELETE statement, etc.!

 

SELECT * FROM Customers WHERE Country=’Mexico’;

 

Operators in The WHERE Clause

The following operators can be used in the WHERE clause:

OperatorDescription
=Equal
<>Not equal. Note: In some versions of SQL this operator may be written as !=
>Greater than
<Less than
>=Greater than or equal
<=Less than or equal
BETWEENBetween a certain range
LIKESearch for a pattern
INTo specify multiple possible values for a column

 

SELECT * FROM Customers WHERE CustomerID=1;