mysql数据库批量替换语句thinkphp

$arr = array(‘kuleiman_goods_option’,’kuleiman_goods_spec’);

$arr=explode(‘,’, $str);

$arr=explode(‘,’, $str);

$a = M();

foreach ($arr as $key => $val) {

$res =  M()->query(“select * from $val limit 1”);

if(!empty($res[0])){

foreach ($res[0] as $k => $v) {

$rr = $a->execute(“UPDATE $val SET $k= REPLACE ( $k,’XXL’, ‘————-‘ )”);

}

}

}