mysql收集

1、字符串拼接、以什么开头、是否包含某个字符串

UPDATE `mc_application` a

SET a.copyright_registration = CONCAT(
'http://op-cp.oss-cn-hangzhou.aliyuncs.com/UPLOAD-PIC/',
a.copyright_registration
)
WHERE
left(a.copyright_registration,4) <> 'http' AND a.copyright_registration  <> ''
and a.copyright_registration is not NULL
and locate(',',a.copyright_registration) = 0;