Re: case-insensitive select?
| From: | Durrani | Date: | Wed, 11 Oct 2000 05:31:26 +0000 |
| Subject: | Re: case-insensitive select? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-3507@lists.php.net to get a copy of this message | ||
Hi
Select field_name from table_name order by field_name;
works fine and is case insensitive.
Regards
Durrani
from India
"Synthetic.Rage" <go@away.com> wrote in message
news:8rvj4i$5mt$1@toye.p.sourceforge.net...
> Hey Y'all;
>
> I have a VARCHAR field in my MySQL database that I've set with the BINARY
> attribute so that I can do a case-sensitive SELECT WHERE. However, I now
> want to do an ORDER BY on this field, and I'd like it to be
> case-insensitive. Any solution to this, either through a specific SELECT
> query, or some routine via PHP after the query has been returned? I'm
using
> PHP4 and MySQL 3.22.32.
>
> Thanks..
>
>
>
>
> --
> 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
>