查找字段中，指定字符串之间的字符串

查询货号，记录一下

select id,cover_pic,detail from xcxmall_goods where id in (SELECT SUBSTRING( attr, LOCATE( '"no":"',  attr )+6,LOCATE( '","bar_code"',  attr )-76 ) submsg FROM `xcxmall_admin_goods`)