SELECT TRIM(TRAILING '.' FROM TRIM(TRAILING '0' FROM product_price)) AS trimmed_price FROM your_table; 注意去掉0和.