• Teach Your Self With
             w3htmlschool.com

MySQL AND operator

One off Mysql Logical operator is AND .The purpose of this operator is to combine two or more Boolean expressions and returns true only if both expressions evaluate to true.If one off condition become false then AND opertor returns false

To filter the result in WHERE clause of the SELECT, UPDATE, DELETE the AND opertor is used.The AND opertor also used with join or letf join clause.

Syntax


SELECT DISTINCT
columns
FROM
table_name
WHERE
column AND column
Table
+----------------+------------+
| Field | Type |
+----------------+------------+
| Code | char(3) |
| Name | char(52) |
| Continent | char(40) |
| Region | char(26) |
| SurfaceArea | float(10,2)|
| IndepYear | smallint(6)|
| Population | int(11) |
| LifeExpectancy | float(3,1) |
| GNP | float(10,2)|
| GNPOld | float(10,2)|
| LocalName | char(45) |
| GovernmentForm | char(45) |
| HeadOfState | char(60) |
| Capital | int(11) |
| Code2 | char(2) |
+----------------+------------+
Example
SELECT Name, Population FROM Country WHERE Population > 100000000 AND (Continent = 'Asia' );
Output
+------------+------------+
| Name | Population |
+------------+------------+
| Bangladesh | 129155000 |
| Indonesia | 212107000 |
| India | 1013662000 |
| Japan | 126714000 |
| China | 1277558000 |
| Pakistan | 156483000 |