How to run MySQL query results in numeric sequence?

Question

I have a simple query where I would like a drop down box to show the results in numeric (integer) order. Below is my query.

Select fv 
FROM fvqc
ORDER BY Value ASC

The results I get are like this -

What I would like to see is this -

you need to make sure your Value field is declared as int() -- If it's varchar() -- That will be the expected result .. Notice al the 1's are first? — Zak
– Zak, Commented Oct 25, 2018 at 23:28

cha · Accepted Answer · 2018-10-25 23:32:45Z

2

You need to cast your values as numeric:

Select fv 
FROM fvqc
ORDER BY CAST(Value AS INT) ASC

answered Oct 25, 2018 at 23:32

cha

10.4k1 gold badge20 silver badges27 bronze badges

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

1 Comment

I figured it was easy. Thank you for your help.