RE: [PHP-DB] how do i select and order by case insensitevly?
| From: | Daevid Vincent | Date: | Wed, 26 Jul 2000 21:22:04 +0000 |
| Subject: | RE: [PHP-DB] how do i select and order by case insensitevly? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1542@lists.php.net to get a copy of this message | ||
I would try to slap an LCASE() or LOWER() around the ORDER BY stuff...
SELECT ... ORDER BY LCASE(name),
then you're output should be correct with upper/lower cases, but sorted
correctly?
> -----Original Message-----
> From: Manuel Lemos [mailto:mlemos@acm.org]
> Sent: Wednesday, July 26, 2000 12:00 AM
> To: Ed Vul
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] how do i select and order by case insensitevly?
>
>
> Hello Ed,
>
> On 25-Jul-00 13:54:28, you wrote:
>
> >Right now I do an order by name
> >and it will do the following:
> >APES
> >BYLINE
> >Bad
> >asbestos
> >etc.
>
> >I want it to sort alphabetically, not using asc II values.
>
> That's the usual sort mode for CHAR fields.
>
> Regards,
> Manuel Lemos
>
> Web Programming Components using PHP Classes.
> Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
> --
> E-mail: mlemos@acm.org
> URL: http://www.mlemos.e-na.net/
> PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
> --
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>