CoreBOSBB

Full Version: Natural Sort

You're currently viewing a stripped down version of our content. View the full version with proper formatting.

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

I just updated the Question on the wiki.

Thanks!