shanxia2.0/docs/sql/qc_material_usage_out_fields_backfill.sql

-- 回填手动出库记录的领用人、用途（从 remark 解析，可重复执行）
SET NAMES utf8mb4;

UPDATE `biz_qc_material_usage`
SET
  `receiver` = TRIM(
    SUBSTRING_INDEX(
      SUBSTRING_INDEX(`remark`, '领用人：', -1),
      '；',
      1
    )
  ),
  `purpose` = TRIM(
    SUBSTRING_INDEX(
      SUBSTRING_INDEX(`remark`, '用途：', -1),
      '；',
      1
    )
  )
WHERE `source_type` = 'manual_out'
  AND `del_flag` = 0
  AND `remark` LIKE '%领用人：%'
  AND (
    `receiver` IS NULL OR `receiver` = '' OR `purpose` IS NULL OR `purpose` = ''
  );