Mysql 同一表字段截取并新更新到另外一个字段中
UPDATE mm_erp_plant e
INNER JOIN (
SELECT
project_unit,
plant_id
FROM
(
SELECT
substring( mep.plant_name, 1, LOCATE( ‘工厂’, mep.plant_name ) - 1 ) AS project_unit,
mep.plant_id as plant_id
FROM
mm_erp_plant mep
) AS m
) AS a ON a.plant_id = e.plant_id
SET e.project_unit = a.project_unit