Sort Only numbers from alphanumeric string in MYSQL

Question

I want to sort last three numbers in following Pattern.

Pattern: 1AB23CD456

I have same pattern strings stored in mysql database.

Output I get:

1ab33cd401

1ab22cd201

1ab11cd101

1ab01cd301

Output I want:

1ab01cd101

1ab11cd201

1ab22cd301

1ab33cd401

And Before sorting last 3 numbers , I would like to sort numbers between ab and cd

I am using PHP server side scripting language, if required

M Khalid Junaid · Accepted Answer · 2014-04-20 15:16:28Z

2

If you want to sort the results with last three numbers you can use mysql's RIGHT() function

SELECT * FROM Table1 ORDER BY RIGHT(numbers,3)

Fiddle Demo

answered Apr 20, 2014 at 15:16

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Akash Sharma Over a year ago

Thanks It worked, Do you know what if i want to sort numbers between ab and cd before sorting last 3 numbers.

Gordon Linoff Over a year ago

@hsaka . . . You should ask another question. Your original question has been answered.

M Khalid Junaid Over a year ago

@hsaka Gordon is right you should ask another question for this but i am not sure for the occurrence of ab and cd's position ,if its same then you can do so fiddle demo

Akash Sharma Over a year ago

@MKhalidJunaid Thanks for your help, But ab and cd can be any character combination.

Collectives™ on Stack Overflow

Sort Only numbers from alphanumeric string in MYSQL

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related