1、去除字段前后特殊符号
SELECT REPLACE(REPLACE(号码,"['",""),"']","") as id from test WHERE 号码 LIKE '%[%'
2、去除字符前后符号,并更新
UPDATE test
SET 号码 = REPLACE(REPLACE(号码,"['",""),"']","")
WHERE 号码 LIKE '%[%'
1、去除字段前后特殊符号
SELECT REPLACE(REPLACE(号码,"['",""),"']","") as id from test WHERE 号码 LIKE '%[%'
2、去除字符前后符号,并更新
UPDATE test
SET 号码 = REPLACE(REPLACE(号码,"['",""),"']","")
WHERE 号码 LIKE '%[%'