1、mysql查询语句
UPDATE permissions
SET name = ( CASE WHEN IFNULL( name, '' ) = '' THEN '' ELSE name END )
WHERE
`name` IS NULL
2、mysql函数replace替换某字段的值
update 表名 set 字段名=REPLACE (字段名,'原来的值','要修改的值')
update partners set type = replace(type,‘4’,‘3’);