MySQL allows you to explicitly convert a number to a string with the help of CAST function. The example below illustrates how to use it.
SELECT 55.5 AS NUMBER, CAST(55.5 AS CHAR) AS CAST_NUMBER;
Output:
+-----------------------+| NUMBER | CAST_NUMBER |+-----------------------+| 55.5 | 55.5 |+-----------------------+
You can observe that the first column is a number whereas the second column has a string value that is also left aligned.
There is also the CONCAT function which implicitly converts NUMBER to STRING when used.
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
