Natural Sort on MYSQL Submitted by kantorious on Thu, 09/01/2011 - 16:19 How can you do natural sort on MySQL? SELECT * FROM table_name ORDER BY column_name + 0, column_name ASC; Technology: mysql Add new comment Your name * E-mail * The content of this field is kept private and will not be shown publicly. Homepage Comment * More information about text formats Text format Filtered HTMLPlain text Filtered HTMLWeb page addresses and e-mail addresses turn into links automatically.You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. The supported tag styles are: <foo>, [foo]. PHP source code can also be enclosed in <?php ... ?> or <% ... %>.Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>Lines and paragraphs break automatically.Plain textNo HTML tags allowed.Web page addresses and e-mail addresses turn into links automatically.Lines and paragraphs break automatically. Notify me when new comments are posted All comments Replies to my comment CAPTCHAThis question is for testing whether you are a human visitor and to prevent automated spam submissions. Math question * 1 + 5 = Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.
Add new comment