Order by string and number |
Hi in my db table i have this string :
ser_14.000_1 ser_14.000_2 ser_14.000_3 ......ser_14.000_n Using $this->orderBy('macchina.seriale * 1 ','asc') i have ser_14.000_1 ser_14.000_2 ser_14.000_20 ser_14.000_3 . HOw can i order by final number ? |
Welcome Guest, Not a member yet? Register Sign In |