UPDATE tablename SET `noids`=(CASE `noids` WHEN ',000' THEN ',".$noid."' ELSE concat(noids,',".$value['noid']."') END) WHERE `userid`='".$value['userid']."' AND `uid`='".$row['uid']."' and find_in_set('".$value['noid']."',`noids`)=0";
转载于:https://my.oschina.net/u/190107/blog/161125