建议使ç¨replaceå½æ°ã
å
·ä½æ¹æ³ä¸ºï¼å°B表å¤ä»½ï¼æ记为BB表å§ï¼ç¶å对B表çbåè¿è¡éå·å符æ¿æ¢å¤çï¼ç»§èå对A表åBB表å
³èæ¥è¯¢ãæç¨å°çè¯å¥åæ¥éª¤ä¸ºï¼
1.create table BB as select b from B ;
2.update BB set b=replace(b,',','');
3.select A.* from A,BB where A.a=BB.b
温馨提示:答案为网友推荐,仅供参考