MySQL WHERE ক্লজে একাধিক মান ফেচ করা

হ্যাঁ, একাধিক মান ফেচ করা সম্ভব, কিন্তু শর্তের জন্য MySQL OR অপারেটর ব্যবহার করতে হয়। প্রথমে একটি টেবিল তৈরি করি:

mysql> create table DemoTable1421 (
    -> EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    -> EmployeeName varchar(20),
    -> EmployeeSalary int
    -> );
Query OK, 0 rows affected (0.82 sec)

কিছু রেকর্ড ইনসার্ট করি:

mysql> insert into DemoTable1421(EmployeeName,EmployeeSalary) values('Chris',10000);
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable1421(EmployeeName,EmployeeSalary) values('Bob',15000);
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable1421(EmployeeName,EmployeeSalary) values('David',8000);
Query OK, 1 row affected (0.09 sec)
mysql> insert into DemoTable1421(EmployeeName,EmployeeSalary) values('Carol',8500);
Query OK, 1 row affected (0.39 sec)
mysql> insert into DemoTable1421(EmployeeName,EmployeeSalary) values('Mike',14500);
Query OK, 1 row affected (0.16 sec)

সব রেকর্ড দেখি:

mysql> select * from DemoTable1421;

আউটপুট:

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
|          1 | Chris        |          10000 |
|          2 | Bob          |          15000 |
|          3 | David        |           8000 |
|          4 | Carol        |           8500 |
|          5 | Mike         |          14500 |
+------------+--------------+----------------+
5 rows in set (0.00 sec)

OR ব্যবহার করে একাধিক মান ফেচ করার কোয়েরি:

mysql> select * from DemoTable1421 where EmployeeId=1 OR EmployeeName='David' OR EmployeeSalary=14500;

আউটপুট:

+------------+--------------+----------------+
| EmployeeId | EmployeeName | EmployeeSalary |
+------------+--------------+----------------+
|          1 | Chris        |          10000 |
|          3 | David        |           8000 |
|          5 | Mike         |          14500 |
+------------+--------------+----------------+
3 rows in set (0.00 sec)