php - How to order by use in codeigniter

one text

Solution:

The order = 0 is a boolean that evaluates to 1 when the value is 1 and otherwise 0. The order part orders the rest of the values in ascending order.

SELECT o.* 
FROM order_1 
ORDER BY `order`= 0, `order`;

See example here