mysql format decimal code example

Example 1: mysql number format

FORMAT( number, decimal_places )

Example 2: mysql text to decimal

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