OR operator
The OR operator is used to combine 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" or class "2nd"
SELECT * FROM tbl_student_record WHERE city='Agra' or class='2nd'Output
| id | name | class | subject | city | phone | fee | fee_date |
|---|---|---|---|---|---|---|---|
| 1 | Mohan | 2nd | Math | Agra | 999999990 | 500 | 2018-01-02 |
| 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 |
| 9 | Mahesh | 3rd | Math | Agra | 999999998 | 800 | 2018-01-24 |
To Learn More in Hindi watch this Video.
Using MySQL OR Operator with example
If love this tutorial Please Like this page