[jQuery] Is there have any JQuery plugin that can sort 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A?

I facing a problem in sorting : 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A Sample data. I using the SQL to sort ASC but it return result as below: 12A 13A 14A 10A 11A 1A 2A 3A 4A 5A 6A 7A 8A 9A May I know is there have any plugin that can sort the sample data above to 1A until 14A? Thanks...

Re: [jQuery] Is there have any JQuery plugin that can sort 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A?

Sort as in a tablesorter parser, an array, or what? On Tue, Feb 2, 2010 at 07:37, HenryRock henryloke.myetr...@gmail.comwrote: I facing a problem in sorting : 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A Sample data. I using the SQL to sort ASC but it return result as below: 12A 13A 14A 10A

Re: [jQuery] Is there have any JQuery plugin that can sort 1A,2A,3A,... 10A, 11A, 12A, 13A, 14A?

Hi, I'm not sure what DBMS you are using but most can sort many ways. You may want to read your DBMS manuals and look for a natural sort method. MySQL uses something like ORDER BY column_name NATURAL ASC or ORDER BY column_name NATURAL DESC. Somewhere on the net should be an old thread about