Press "Enter" to skip to content


MySQL WHERE clause

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


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
divInterger Division

Comparison Operator  for MYSQL where Clause

<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                   
ANDLogical AND
ORLogical OR
XORLogical exclusive OR
NOTLogical negation