怎么在sql中把数据中取出的数据转换为想要的内容

例如我想把数据库存查询出的1 ，2 ，3 转换为一分厂，二分厂。三分厂。因为页面没做处理。

欢迎使用Markdown编辑器

SELECT
a.placename AS “placename”,
a.ds AS “dsCount”,
a.optime as optime,
( CASE
WHEN (a.factoryname = 1) THEN
‘一分厂’
WHEN (a.factoryname = 2) THEN
‘二分厂’
WHEN (a.factoryname = 2) THEN
‘三分厂’
end ) as factoryname
FROM
(select a.placename,a.optime,a.factoryname, COUNT(*) as ds FROM ce_bf_l_ex_t a

	where
	    placename = '1'
		AND factoryname = 1
	GROUP BY a.placename,a.optime,a.factoryname) as a