How to list out the numbers between the range using mysql query?
===

Maintain range in a separate rangetable(Fields are:place,frmrange,torange). 

Records(Chennai,0,20 ) and(Trichy,20,40). And i have a another table 

recordtable(series,place,orderconfirm) (1,Chennai,yes)(2,Chennai,yes) upto (5,Chennai,yes) 

these are used in the range (0 to 20). i want to print remaining unused series range(For Ex: 

0,6to20).  