Re: case-insensitive select?

Not when the binary attribute is set. Binary sorting is case-sensitive, amd I need that binary flag to be there for something else. ""Durrani"" <durrani@comatindia.com> wrote in message news:8s0tis$s38$1@toye.p.sourceforge.net... > 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 > > > > > > -- > 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 >