Re: MySQL BETWEEN Problems
| From: | Brad Bonkoski | Date: | Fri, 18 May 2007 20:18:24 +0000 |
| Subject: | Re: MySQL BETWEEN Problems | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43615@lists.php.net to get a copy of this message | ||
I think you need between 'A' and 'F%'
Aa is between A and F
but 'Fa' is not between 'A' and 'F'
(but 'Ez' would be between 'A' and 'F')
-B
Tony Grimes wrote:
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