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.
