SQL to replace product id how to?

[explorer1979]

Hi all,

My shop have some products that like that

for example the product id:
This is the target product that starting from 00 or 000
001234
000348

And some other products that have the chart. have the 0 or 00 etc, such as E00112-B, AWD-001 that we don't want to touch them or change, since they are not our change target.

Then now, my thinking is, make change of the 001234 to EK001234, 000348 to EK000348 etc. all add the EK on it id before.

I have the permission can access the MySQL server database and table by using phpmyadmin, anyone can tell me how to make above change to all the 00XXXX and 000XXX products quickly and safe by SQL?

Thank you very much of your time and kindly help.

[DrByte]

product ID must ONLY be numeric.

[explorer1979]

Hi All,

The Product id is same mean of Model No. Sorry to make the mistake there.

My mean is how to Model: 00XXX change to Model: EK00XXX by SQL

Thx

[haredo]

Back up your database first..... Very Important...


UPDATE products
SET products_model = 'EK00XXX'
WHERE products_model = '00XXX'

[explorer1979]

Hi herado,

Thank you very much...

but one more question....
the XXX is a different value there just for example....

For example 001234, 005489, 004566, 000234 etc... so I just said it as 00XXX is for easy understand ...


For the MySQL's SQL... How to make it know I just change all value start from 00, and 000 to EK00, EK000?

Your value in the SQL example of 00XXX to EK00XXX is a absolute value, how do it know need to change all value starting from 00?

Thank you very much again of your kindly help and time.

[explorer1979]

Hi all,

Final find this way work for me.

UPDATE products
SET products_model = CONCAT('EK',products_model)
WHERE manufacturers_id = 11
AND products_model NOT LIKE 'EK%'

[haredo]

Ty for posting the solution ....