Retrieve values between two numbers in mysql

[rajasri]

Guys today we are going to know how to retrieve the values between two specific numbers using mysql command.
See the example below
Get the id values in two numbers or simply assign it like n1=1,n2=5.
Now use

select * from tablename where id BETWEEN '"+n1+"' AND '"+n2+"'.

This will retrieve all table values from id=1 to 5. Any doubt ask us.Do comment us to help you.

Happy Coding