Mysql字符串字段计算

//ROUND(xxx)   四舍五入运算函数
SELECT
	     c.P_DEAIL_ID,
	     d.SYNOPSIS synopsis,
	     sd.DISCOUNT discount,//左连接查询结果中的折扣
	     d.ORIGINAL_PRICE originalPrice,//表中原有的原价
	     ROUND( d.ORIGINAL_PRICE * sd.DISCOUNT * 0.1 ) currentPrice 
FROM
	m_xxxx c
	LEFT JOIN m_p_detail d ON c.P_DEAIL_ID = d.ID 
	LEFT JOIN m_user u ON c.USER_ID = u.ID
	LEFT JOIN m_super_discount sd ON sd.SUPER_ID = u.SUPER_ID 
	AND sd.USER_LEVEL = u.USER_LEVEL 
WHERE
	     c.USER_ID = 132xxx 
	AND c.P_DEAIL_ID = d.ID 
ORDER BY
	     c.ADD_DATE DESC

效果: