Right Order_By (integer)

[eluser]R. Oerlemans[/eluser]
[quote author="waldmeister" date="1254072715"]What are the values of your 'snelheid' column?
"3 Mb/s" or just 3?

If it's the later, then you shouldn't have that problem.
If it's the first, then you could try this:

Code:

$query_s = $this->db->group_by('snelheid')
                                            ->order_by("cast(substring_index(test, ' Mb/s', 1) as signed)", "ASC")
                                                ->get('abonnementen')
                                                    ->result_array();

[/quote]

It's just 3, wich code could i use now?