How to Convert a String to Number in MySQL

In MySQL, the code written in earlier example for SQL Server containing CONVERT() no longer  works, instead it can be written as follows:

---

SELECT *

FROM demo

ORDER BY CONVERT(txtcolumn, SIGNED INTEGER);

---