Re: case-insensitive select?

Then do something like ORDER BY UPPER(fieldname). Oh, wait! <ASBESTOS>All standard MySQL lack-of-functionality-and-standards-compliance disclaimers apply.</ASBESTOS> Actually, the MySQL folks are doing some pretty marvellous things, and their product is coming along at a rapid pace. You might want to type up your requirement and present it to them if you cannot simply use UPPER (or somehow otherwise fold the field, as SQL requires). Doug At 02:58 PM 10/17/00 -0700, Synthetic.Rage wrote: >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.. >> >