如何将sql查询到的字段名换成自己想要展示成自己想要的东西

以下内容仅作为个人笔记使用。

两种方法
1，直接在sql查询语句中将字段替换掉
举个栗子：select count(1), s2dpt.name,s2dpt.id
from face_user_library as ful
left join face_user_department fud
on fud.face_user = ful.id
left join sys_dept sdpt
on sdpt.id = fud.department
left join sys_dept s2dpt
on s2dpt.id = sdpt.parent_id
where ful.face_type = 0 and ful.del_flag = 0 and s2dpt.id is not null
group by s2dpt.id
查询结果为：***学院
现在想要把学院两个字去掉，将sql修改为：
select count(1), replace(left(s2dpt.name, 11),‘学院’,’’) as screen,s2dpt.id
from face_user_library as ful
left join face_user_department fud
on fud.face_user = ful.id
left join sys_dept sdpt
on sdpt.id = fud.department
left join sys_dept s2dpt
on s2dpt.id = sdpt.parent_id
where ful.face_type = 0 and ful.del_flag = 0 and s2dpt.id is not null
group by s2dpt.id
则查询结果为：

其中：replace(left(s2dpt.name, 11),‘学院’,’’)的意思是取s2dpt.name字段的左边10位，如果有学院两个字，就去掉
2，在实体中处理：
然后在controller中：

查询结果也同样可以去掉学院二字
但是一般不在sql中这样修改，所以推荐使用第二种方法。