MySQL WHERE clause

The MYSQL where clause is the mechanism for selecting the row you want for your result set.

SYNTAX

SELECT DISTINCT
columns
FROM
table_name
WHERE where_conditions;

Example for MySQL WHERE clause

SELECT code,name from Country where continent=”asia”

Output for MySQL WHERE clause

mysql> SELECT code,name from Country where continent=”asia”;
+——+———————-+
| code | name |
+——+———————-+
| AFG | Afghanistan |
| ARE | United Arab Emirates |
| ARM | Armenia |
| AZE | Azerbaijan |
| BHR | Bahrain |
| BGD | Bangladesh |
| BTN | Bhutan |
| BRN | Brunei |
| PHL | Philippines |
| GEO | Georgia |
| HKG | Hong Kong |
| IDN | Indonesia |
| IND | India |

expressions in WHERE clauses can use the following type of operation:

Arithmetic for calculation
Camparison for comparison of one expression with another expression.
Logical to combine different WHERE condition.

Parameter For MySQL WHERE clause

Arithmetic Operation used in Mysql Where Clause

Operation	Definition
+	Addition
–	Subtraction
*	Multiplication
/	Division
div	Interger Division
%	Modulo

Comparison Operator for MYSQL where Clause

Operation	Defination

<	Less then
>=	Less then or equal to
=	Equal to
<=>	Equal (work even for NULL values)
<> or !=	Not equal to
>=	Greater than or equal to
>	Greater than or equal to
Between … and. .	Indicate a range of values

Logical Operator For where Clause

Operation	Definition
AND	Logical AND
OR	Logical OR
XOR	Logical exclusive OR
NOT	Logical negation

mysql-where