Is 'BETWEEN m and n' supposed to work for ENUM fields?

[Terry West]

In a small test table with 1 enum field and four records
(with values 'a','b','c' and 'd'), I find the following selects work:

  select * from enumtest where colname between 'b' and 'c'
  select * from enumtest where colname > 1 and colname < 4

but this does not:

  select * from enumtest where colname between 2 and 3

Just wondering if the latter is supposed to work.  I've tried
this test on Linux 3.23.2 and Solaris 3.22.20a.

    Terry West
    <terry@stripped>