MySQL Forums
Forum List  »  Newbie

HOW TO SORT A COLUMN WITH ALPHANUMERIC
Posted by: Olumide Adebayo
Date: April 28, 2016 08:21AM

I have a table named "BILLSCHARTS" with so many columns. I want to display the record and sort it by title.

The title column is a text value and example of the values are

HB 02 : Fiscal Policy Act
HB 35: Appropriation Act
HB 03 : Labour Law
HB 21: Appropriation Amendment Act
HB 14: Money Laundering Prohibition Act


I want to sort the table and have the following example as the output in that order:

HB 02 : Fiscal Policy Act
HB 03 : Labour Law
HB 14: Money Laundering Prohibition Act
HB 21: Appropriation Amendment Act
HB 35: Appropriation Act



Although, i have tried but the result am getting is displaying zeros first, then 1's , 2's , 3's etc.


I need your kind assistance with the sql query to use in achieving my goal.


Your kind assistance will be valued.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
HOW TO SORT A COLUMN WITH ALPHANUMERIC
April 28, 2016 08:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.