বেস টেবিল থেকে মানের রেঞ্জ সিলেক্ট করে MySQL ভিউ তৈরি করা (BETWEEN)

MySQL BETWEEN অপারেটর ব্যবহার করে নির্দিষ্ট রেঞ্জের মান সিলেক্ট করে ভিউ তৈরি করা যায়।

উদাহরণ

student_info বেস টেবিল:

mysql> SELECT * FROM Student_info;
+------+---------+------------+------------+
| id   | Name    | Address    | Subject    |
+------+---------+------------+------------+
|  101 | YashPal | Amritsar   | History    |
|  105 | Gaurav  | Chandigarh | Literature |
|  125 | Raman   | Shimla     | Computers  |
|  130 | Ram     | Jhansi     | Computers  |
|  132 | Shyam   | Chandigarh | Economics  |
|  133 | Mohan   | Delhi      | Computers  |
+------+---------+------------+------------+

Name 'C' থেকে 'P' রেঞ্জে থাকা রেকর্ডের ভিউ:

mysql> CREATE OR REPLACE VIEW Info AS
    -> SELECT * FROM student_info WHERE Name BETWEEN 'C' AND 'P';
Query OK, 0 rows affected (0.14 sec)

mysql> SELECT * FROM info;
+------+--------+------------+------------+
| id   | Name   | Address    | Subject    |
+------+--------+------------+------------+
|  105 | Gaurav | Chandigarh | Literature |
|  133 | Mohan  | Delhi      | Computers  |
+------+--------+------------+------------+

NOT BETWEEN ব্যবহার করে বিপরীত রেঞ্জ:

mysql> CREATE OR REPLACE VIEW Info AS
    -> SELECT * FROM student_info WHERE Name NOT BETWEEN 'C' AND 'P';
Query OK, 0 rows affected (0.06 sec)

mysql> SELECT * FROM info;
+------+---------+------------+-----------+
| id   | Name    | Address    | Subject   |
+------+---------+------------+-----------+
|  101 | YashPal | Amritsar   | History   |
|  125 | Raman   | Shimla     | Computers |
|  130 | Ram     | Jhansi     | Computers |
|  132 | Shyam   | Chandigarh | Economics |
+------+---------+------------+-----------+