Select order by substr of a field

[yrrahxob]

I have the following query but it doesn\'t work. I get error code 1064.

 

SELECT * FROM `aud_desc` order by substr(aud_code,1,1)

 

Is it possible to do a select and order it by a substr of a column.

 

Please help

 

Thank you

[Kriek]

In MySQL use the SUBSTRING() function.

 

SELECT * FROM aud_desc ORDER BY SUBSTRING(aud_code, 1, 1);