[RESOLVED] Order by

[Double_M]

Hi,

I suppose this might be mainly an sql question but, is there a way to order the sql result by largest string in a column?

You could use an array to sort the result but i was just wondering if there was a direct way using the sql statement.

Any help much apreciated.

[bradgrafelman]

You could probably order by the CHAR_LENGTH() or LENGTH() of that column... visit the MySQL manual page String Functions for more information.

[Double_M]

Excellent! 😃

That worked a treat! Thanks very much!