How to perform natural sorting on model and result should be in ActiveRecord::Relation ?

[Fahim Patel]

Hello All,

I need to perform natural sorting on alphanumeric column's data and even return  type should be ActiveRecord::Relation. I tried 'naturally' and ''naturalsorter'' gem but not successful.Below link explain what is natural sorting. 

http://www.copterlabs.com/blog/natural-sorting-in-mysql/    

Thanks! in advance

[Fahim Patel]

Found the solution. Change the 'col_name' with your table alphanumeric column name. 

MyModel.order("LENGTH(col_name)").order(:col_name)