returning all values from stored lower and upper bound range

[chucklarge]

hi,

i am keeping track of a range of numbers by inserting a lower and upper bound. I want to retrieve every value in that range with a query, is this possible?

for example,

i want to keep track of 1,2,3,4,5,6,7,8,9,10
so i store 1 and 10 in two columns
then with a query i want to retrieve 1,2,3,4,5,6,7,8,9,10

I realize that i can create the values with php, but i want to see if there is a way to do this within mysql.

thanks,
chuck

[mourisj]

Try to do something like :

select * from tablename
where num BETWEEN 1 and 10

Greetings,

JJ Mouris