CONCAT & SUBSTR 的使用

update table set web58_tree_id = CONCAT(SUBSTR(tree_id, 3, 0),"001",SUBSTR(tree_id, 4)) where tree_id like '003001%' and web58_tree_id is null and id>1218