ORDER BY alphabet first then follow by number

by

Use the following ORDER BY clause:

ORDER BY IF(name RLIKE '^[a-z]', 1, 2), name

More Related Contents:

  1. How to find similar results and sort by similarity?
  2. How does MySQL process ORDER BY and LIMIT in a query?
  3. Ordering by the order of values in a SQL IN() clause
  4. Ordering by specific field value first
  5. MySQL “Group By” and “Order By”
  6. Using union and order by clause in mysql
  7. SQL order string as number
  8. MySQL: Sort GROUP_CONCAT values
  9. MySQL order by “best match”
  10. Order by COUNT per value
  11. MySQL/MariaDB – order by inside subquery
  12. ORDER BY date and time BEFORE GROUP BY name in mysql
  13. updating columns with a sequence number mysql
  14. Mysql: Order by like?
  15. Sort the rows according to the order specified in WHERE IN clause
  16. MYSQL Select One Random record from each Category
  17. Remove duplicate rows in MySQL
  18. Error Code: 2013. Lost connection to MySQL server during query
  19. SQL Performance UNION vs OR
  20. How do I select an entire row which has the largest ID in the table?
  21. View’s SELECT contains a subquery in the FROM clause
  22. Can MySQL replace multiple characters?
  23. Difference between these two joining table approaches?
  24. Select a column with a keyword name
  25. MySQL Stored Procedures not working with SELECT (basic question)
  26. ERROR 1148: The used command is not allowed with this MySQL version
  27. Use Composite Primary Key as Foreign Key
  28. MySQL Select minimum/maximum among two (or more) given values
  29. SQL (MySQL) vs NoSQL (CouchDB) [closed]
  30. MySQL update statement to store ranking positions

Leave a Comment