MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:SGreen Date:July 28 2004 12:57pm
Subject:Re: Using function followed by "order by function_name(table.field_name)".....
View as plain text  
I hope you have already tried just plain-old "ORDER BY field_name" in your 
query.  What is wrong with the default order presented? Can you show an 
example of how the ORDER BY did not solve your problem along with an 
example of what it should have been for your situation?

Thanks in advance,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine


"Scott Fletcher" <SFletcher@stripped> wrote on 07/27/2004 05:29:05 PM:

> I'm having a little bit of a trouble with the use of the SQL function...
> What I have here is a webpage that show the row of data, the web user
> get to click on the field to sort the row by the field name.  So, when I
> use "order by char(field_name)", the data doesn't turned out right in
> alpha-numeric in ascending order...
> 
> 
> 
> --snip--
> 
> Debug Test (WM Account) 1
> 
> ABC Company
> 
> Riverknoll A C
> 
> SDFONE'sdf
> 
> SeaWater
> 
> --snip--
> 
> 
> 
> I would like the first few letter of each row be in correct
> alpha-numeric order regardless of what character is there in the data,
> like (, ), ', ?, etc...
> 
> 
> 
> Thanks,
> 
>  FletchSOD
> 

Thread
Using function followed by "order by function_name(table.field_name)".....Scott Fletcher27 Jul
  • Re: Using function followed by "order by function_name(table.field_name)".....SGreen28 Jul
RE: Using function followed by "order by function_name(table.field_name)".....SGreen28 Jul
RE: Using function followed by "order by function_name(table.field_name)".....SGreen28 Jul