查询 SELECT substring_index(substring_index(lj,'&buyParam=',-1),'_1_',1) FORM lj 更改 UPDATE lj SET spid=substring_index(substring_index(lj,'&buyParam=',-1),'_1_',1)
小涛