select 
 pd.name
 ,p.model
 ,concat(
  substr(pd.name,locate(m.name,pd.name)+length(m.name)+1)
  ,substr(p.model,locate(p.model,'-'))
 ) as new_model
from oc_product p
join oc_product_description pd on p.product_id=pd.product_id
join oc_manufacturer m on manufacturer_id=p.manufacturer_id

update oc_manufacturer v, oc_product p, oc_product_description d
set p.model = 
    /* concat( */
        ltrim(substring(d.name, instr(d.name, v.name) + char_length(v.name)))
    /*    , case 
            when p.model regexp '-[0-9]+$' then 
                concat('-', substring_index(p.model, '-', -1))
            else '' 
        end
    ) */

where
  p.manufacturer_id = v.manufacturer_id and 
  d.product_id = p.product_id and
  p.product_id = 100 and
  instr(d.name, v.name) > 0;

update oc_manufacturer v, oc_product p, oc_product_description d
set p.model = concat (ltrim(substring(d.name, instr(d.name, v.name) + char_length(v.name))),'-02')

where
  substr(model, -3) = '-02' and
  p.manufacturer_id = v.manufacturer_id and 
  d.product_id = p.product_id and
  p.product_id = 100 and
  instr(d.name, v.name) > 0;