AND
The AND operator allows the existence of multiple conditions in an SQL statement's WHERE clause.
Consider the tbl_student_record table having the following records
id | name | class | subject | city | phone | fee | fee_date |
---|---|---|---|---|---|---|---|
1 | Mohan | 2nd | Math | Agra | 999999990 | 500 | 2018-01-02 |
2 | Pooja | 3rd | English | Delhi | 999999991 | 200 | 2018-01-11 |
3 | Rahul | 4th | Math | Agra | 999999992 | 300 | 2018-01-05 |
4 | Suresh | 2nd | English | Agra | 999999993 | 400 | 2018-01-22 |
5 | Vivek | 3rd | Math | Agra | 999999994 | 500 | 2018-01-01 |
6 | Anuj | 2nd | English | Delhi | 999999995 | 600 | 2018-01-31 |
7 | Sanju | 4th | Math | Agra | 999999996 | 400 | 2018-01-17 |
8 | Rohit | 3rd | English | Delhi | 999999997 | 700 | 2018-01-10 |
9 | Mahesh | 3rd | Math | Agra | 999999998 | 800 | 2018-01-24 |
10 | Munesh | 4th | English | Delhi | 999999999 | 200 | 2018-01-09 |
The following SQL statement selects all fields from "tbl_student_record" where city is "Agra" AND class must be "2nd"
SELECT * FROM tbl_student_record WHERE city='Agra' and class='2nd'
Output
id | name | class | subject | city | phone | fee | fee_date |
---|---|---|---|---|---|---|---|
1 | Mohan | 2nd | Math | Agra | 999999990 | 500 | 2018-01-02 |
4 | Suresh | 2nd | English | Agra | 999999993 | 400 | 2018-01-22 |
To Learn More in Hindi watch this Video.
Using MySQL AND Operator with example
If love this tutorial Please Like this page