Re: MySQL BETWEEN Problems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



So just change it to WHERE last_name BETWEEN 'A' AND 'G' .  That'll get you
Aa-Fz :)


On 5/18/07, Tony Grimes <contact@xxxxxxxxxxxxxx> wrote:

We tried that and it didn't work. We've also tried every combination of
upper and lower case too.

Tony


On 5/18/07 2:18 PM, "Brad Bonkoski" <bbonkoski@xxxxxxxxxxxxxx> wrote:

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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux