Natural Sort Grocery Crud results

Asked Jul 31 '12 at 11:37

Active Jul 31 '12 at 11:37

Viewed 738 times

Grocery Crud provides the function order_by:

void order_by(mixed $order_by [, string $direction] )

However the field I need to sort is a varchar and I need to perform natural sorting. The MySQL query which correctly sorts the list is as follows:

ORDER BY 0+'field_name' ASC

Is there any way to specify '0+' in Grocery Crud?

thanks

asked Jul 31 '12 at 11:37

SO_tourist

Not sure, but how about $crud->order_by('CONCAT(0,field_name)','ASC'); – goFrendiAsgard Aug 24 '12 at 01:24
Can you left pad the column value with enough 0's to ensure that all numbers in the column will have the same string length? – mickmackusa Dec 16 '22 at 06:10

0 Answers0