update test2 set aaa = SUBSTRING(title, LOCATE(‘id=‘, title) + 3, (LOCATE(‘&prjid=‘, title) - LOCATE(‘id=‘, title) - 3));
mysql 字符串截取、位置查询
原文：https://www.cnblogs.com/scode2/p/12484622.html
