Thread Rating:
  • 1 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Natural Sort
#1
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
  • vtiger 5.21:      Ubuntu 12.04LTS on INTEL, Zyxel NSAs 325v2, 540 on ARM
  • CoreBOS 5.5:   Ubuntu 12.04LTS on INTEL, Zyxel NSAs 325v2, 540 on ARM
  • Dolibarr 3.8.x:  Ubuntu 12.04LTS on INTEL, Zyxel NSAs 325v2, 540 on ARM
Reply
#2
I just updated the Question on the wiki.

Thanks!
Joe
TSolucio
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)