mysql what type choose to decimal number in table code example
Example 1: mysql text to decimal
SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName
Example 2: mysql decimal
column_name DECIMAL(5,2)
SELECT CAST(colName AS DECIMAL(10,2))
FROM tableName
column_name DECIMAL(5,2)