Home » Mysql » Alpha Numeric Sorting in MySQL

Alpha Numeric Sorting in MySQL

Alpha Numeric Sorting in MySQL

Today i will explain how to sort the Aplhanumeric(alphabets and Numeric mixed) values in Mysql database.First we have create a Employee table to demonstrate the mixed sorting.

Create Employee table

Insert mixed data having in same manner

Now to short the Mysql table data, Like as 1,2b,60b,3c,70d,8a run below query

, , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">