MySQL range
May times the programmer needs to find out some specific data which lies in the particular range of values but there is not any predefined function in MySQL but we can also find that particular range's data from the database in MySQL using BETWEEN and AND clauses or write your own simple query.
Syntax:
exp BETWEEN min_value AND max_value |
The above syntax is equivalent to the expression (min_value <= exp AND exp <= max_value).
In the following example we will describe you that how one can find out specific data lying between some range. To fire query we must have some data into a table therefore we will first create a table and fill some data into it.
Query | CREATE TABLE `mca` ( `id` bigint(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `subject` varchar(255) default NULL, PRIMARY KEY (`id`) ) ; /*Data for the table `mca` */ insert into `mca`(`id`,`name`,`subject`) values (1,'Amit','Computer'), (2,'Ramesh','Computer '), (3,'Suman','Computer'),(4,'Vineet','Java'),(5,'Sandeep','C++'); |
Output |
+----+---------+-----------+ | id | name | subject | +----+---------+-----------+ | 1 | Amit | Computer | | 2 | Ramesh | Computer | | 3 | Suman | Computer | | 4 | Vineet | Java | | 5 | Sandeep | C++ | +----+---------+-----------+ |
Now suppose we want to know the persons record which lies between the id ranges from 2 to 5 then we can do this with the following query
Query | SELECT id, name, subject from mca where mca.id BETWEEN 2 AND 5; Above query can also be written as below: SELECT id, name, subject from mca where |
Output |
+----+---------+-----------+ | id | name | subject | +----+---------+-----------+ | 2 | Ramesh | Computer | | 3 | Suman | Computer | | 4 | Vineet | Java | | 5 | Sandeep | C++ | +----+---------+-----------+ |