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:

<>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;