+- 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!