CoreBOSBB
Natural Sort - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Development (https://discussions.corebos.org/forumdisplay.php?fid=18)
+--- Forum: coreBOS Development (https://discussions.corebos.org/forumdisplay.php?fid=4)
+---- Forum: coreBOS (https://discussions.corebos.org/forumdisplay.php?fid=5)
+---- Thread: Natural Sort (/showthread.php?tid=217)



Natural Sort - Peter A. Gebhardt - 12-15-2015

Just saw:

http://corebos.org/documentation/doku.php?id=en:adminmanual:faq#automatic_number_fields_are_no

I'm using e.g.:

Code:
SELECT * FROM vtiger_accounts ORDER BY LENGTH(account_no), account_no;

found here:

http://stackoverflow.com/questions/153633/natural-sort-in-mysql/12257917#12257917

Best regards


RE: Natural Sort - joebordes - 12-15-2015

I just updated the Question on the wiki.

Thanks!