mysql 中能不能把int 转换为string

[shangxuan]

SELECT fittingsequipinfo.fittingID, fittingName, price, GROUP_CONCAT( DISTINCT `fittingCategory` 
ORDER BY `fittingCategory` 
SEPARATOR "," ) AS re,GROUP_CONCAT(  `Equipmentamount`
ORDER BY `fittingCategory` 
SEPARATOR "," ) AS re2

FROM `fittingsequipinfo` 
LEFT JOIN fittingsinfo ON fittingsequipinfo.fittingID = fittingsinfo.fittingID
GROUP BY fittingID

第一个GROUP_CONCAT 没什么问题，但是第二个有问题了，因为 `Equipmentamount` 是int，而不是varchar

[WWWWA]

CAST(Equipmentamount as CHAR(20))

[懒得去死]

concat(Equipmentamount,'')