"expr BETWEEN ... AND ..." with @variable syntax problems...

[shadedecho]

I am having a great deal of difficulty finding sufficient documentation on the "BETWEEN ... AND" operator functionality in MySQL, in particular, how (if possible) to use it with a variable.

Before I ask that question though, a little ground work: You may be familiar with the ability to query MySQL without referencing a table, such as:

SELECT TO_DAYS('2002-01-15') AS 'datevar'

would return:

datevar
_______
731230

I would like to use this ability as well as "BETWEEN ... AND" to have MySQL return a result set with a range of values... for instance, something like this:

SELECT @a WHERE @a BETWEEN 3 AND 8

and have MySQL return a result set like this:

3
4
5
6
7
8

Can anyone help me with how I would syntactically structure such a query?

 

[sleipnir214]

"BETWEEN...AND" is a logical comparison operator, not a looping construct. It won't do what you want it to do. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[shadedecho]

What I was getting at (but didn't actually come out and say) in my previous post was that I wanted to set up a looping construct whose "terminating condition" was a false from the BETWEEN ... AND logical constructor. Does anyone know how to do this?

 

[sleipnir214]

I was not clear either.

You can't loop in a MySQL query. You will have to do it in your MySQL-external programming language. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!