Pak Jiddat

Read: In the name of thy Lord Who createth, Createth man from a clot. Read: And thy Lord is the Most Bounteous, Who teacheth by the pen, Teacheth man that which he knew not. Nay, but verily man is rebellious That he thinketh himself independent!. Lo! unto thy Lord is the return. (Sura Alalaq 96:8)

Sorting a MySQL string column as a number

Created On: 01 Jul, 2017: 11:40:59 - Tags : database management

Url: https://stackoverflow.com/questions/44829035/wordpress-sort-posts-containing-numbers-and-letters-alphabetically/44857800#44857800

To sort a MySQL string column containing a number we can use the SUBSTRING and CAST functions. The SUBSTRING function should extract the numbers inside the string. The CAST function will convert the extracted string to a number.


Related Articles

  1. Removing ONLY_FULL_GROUP_BY sql mode
  2. Upgrading Postgresql from version 9.4 to 9.6
  3. Upgrading MySQL server from version 5.6 to 8.0
  4. Ignoring errors during MySQL import
  5. MariaDB/MySQL user password not being set
  6. MySQL server out of resources
  7. MySQL Tuner
  8. Create backup of Mongo Db database
  9. Deleting a Mongo Db database
  10. Restoring a database backup in Plesk
  11. How to login to MySQL server as root user on Plesk
  12. List all databases for Postgresql
  13. Solution for mysql header mismatch error
  14. Backing up and Restoring MongoDB data
  15. Removing Replication in MongoDb
  16. Exporting Mysql database data in CSV format using Mysql Work Bench