Check out example codes for "mysql text to decimal". It will help you in understanding the concepts better.

Code Example 1

SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName

Learn ReactJs, React Native from akashmittal.com