MySQL String to Number: CAST & CONVERT Guide

1 year ago
Olivia Parker
1 minute

In MySQL, there is no built-in TO_NUMBER function. Typically, the TO_NUMBER function is used to convert a string to a number data type. In MySQL, you can use the CAST or CONVERT functions to achieve similar functionality.

For example, you can utilize the following syntax to convert a string into a numeric type:

SELECT CAST('42' AS SIGNED);

Or:

SELECT CONVERT('42', SIGNED);

This will convert the string ’42’ to the integer 42. Strings can be converted to different numeric types as needed, such as SIGNED, UNSIGNED, DECIMAL, and so on.

bannerAds