For Programmers: Free Programming Magazines  


Home > Archive > PHP DB > May 2007 > MySQL BETWEEN Problems









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MySQL BETWEEN Problems
Tony Grimes

2007-05-18, 6:58 pm

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
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com