CONCAT()函数,里面是拼接的参数
update BPMI_TASK set TaskName= CONCAT('【',InitUserName,'】','出差申请')
where ProcessName='出差申请' and TaskName like '%【】%'
CONCAT()函数,里面是拼接的参数
update BPMI_TASK set TaskName= CONCAT('【',InitUserName,'】','出差申请')
where ProcessName='出差申请' and TaskName like '%【】%'