1. mysql中合并两个字符串
select concat(a.empno,’/’,a.user_id,’/’,a.username) as newcolumn from table as a
- 将table中,字段empno,user_id,username的串进行合并,并使用分隔符‘/’连接起来,并存储到一个新列中;
- 在Django中,view模块查询数据并显示,特殊符号需要进行转译
==Django View Mysql: ==
select concat(a.empno,’/\’,a.user_id,’/\’,a.username) as newcolumn from table as a
2. 判断字段中是否含有某一字符串
(
case
when b.email like ‘%%partner%%’ then ‘Partber’ *如果字段中含有字符partner
locate(‘partner’,b.email)=0 then ‘Samsung’ *如果字段中含有partner, ->1; 如果字段中不含有partner,->0
end
)as employee
Django view 中:
def workstatus(request):
datasql="select a.id,a.drecorddate,c.empno,c.username,a.te