MySQL where condition

5 (100%) 1 vote

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:

Operator Description
= 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
BETWEEN Between a certain range
LIKE Search for a pattern
IN To specify multiple possible values for a column

 

SELECT * FROM Customers WHERE CustomerID=1;

 

For any query or issue, feel free to discuss on http://discuss.eduguru.in
%d bloggers like this: