去除单引号：

UPDATE order_express SET express_code=TRIM(BOTH “‘” FROM express_code);

默认去除两端空格：

UPDATE order_express SET express_code=TRIM( express_code);