Right Order_By (integer)

[eluser]Johan André[/eluser]
Usually when I have rows like this:

Code:

name
----------
Pool 1
Pool 2
Pool 3
Pool 4
...
Pool 10
Pool 11

and sort them based on name they end up like Pool 1, Pool 10...
Sorting like this helps:

Code:

$this->select('*');
$this->from('table');
$this->order_by('LENGTH(name), name ASC');