-- Fix Vince brands in products_master (match exact word "Vince" with any surrounding characters)
UPDATE products_master 
SET 品牌 = 'Vince' 
WHERE 线上宝贝名称 LIKE '%Vince%'
  AND (品牌 IS NULL OR 品牌 != 'Vince');

-- Fix Vince brands in procurement_orders (match exact word "Vince" with any surrounding characters)
UPDATE procurement_orders 
SET 品牌 = 'Vince' 
WHERE 线上宝贝名称 LIKE '%Vince%'
  AND (品牌 IS NULL OR 品牌 != 'Vince');

-- Verify the updates
SELECT '=== Products Master ===' as section;
SELECT 品牌, COUNT(*) as count 
FROM products_master 
WHERE LOWER(线上宝贝名称) LIKE '%vince%' 
GROUP BY 品牌;

SELECT '=== Procurement Orders ===' as section;
SELECT 品牌, COUNT(*) as count 
FROM procurement_orders 
WHERE LOWER(线上宝贝名称) LIKE '%vince%' 
GROUP BY 品牌;