Home » Mysql » Alpha Numeric with seprater Sorting in MySQL

Alpha Numeric with seprater Sorting in MySQL

Alpha Numeric with seprater 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

TRUNCATE TABLE employee;

Insert New mixed data having in same manner

Now to short the Mysql table data string(combination og alphabet and number with hyphen just like A-1,A-8,A-3,B-2,B-25).We write below maintain 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="">