Order by in Database join

[digitalDave]

I am trying to order a list of numbers in a database join element.
I am using the data where tab.

my list of numbers is 1,5,9,11,22 and I would like them ordered in that order.

If I order by the number itself I get 1,11,22,5,9.

How do I achieve this please?

 

[troester]

You can do
ORDER BY CONVERT(`your-column`,UNSIGNED)

 

[digitalDave]

Fantastic as always troester