MySQL BETWEEN Problems
| From: | Tony Grimes | Date: | Fri, 18 May 2007 19:56:35 +0000 |
| Subject: | MySQL BETWEEN Problems | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-43614@lists.php.net to get a copy of this message | ||
I'm using BETWEEN to return a list all people who's last names fall between
A and F:
.... WHERE last_name BETWEEN 'A' AND 'F' ...
but it's only returning names between A and E. The same thing happens when I
use:
.... WHERE last_name >= 'A' AND last_name <= 'F' ...
Shouldn't this work the way I expect it? What am I doing wrong?
Tony