How to Convert Product Reference

I need to change our free-format product references to a masked numbering format. I can’t seem to tell the script to change all product reference numbers to PP1001, PP1002, PP1003 etc.

Obviously the below script is only for product with rowid 10… I would try to change that to <1 once I can get the mysql script sorted.

UPDATEcl13-dolibarr.llx_productSETref= concat('PP','1000'+1) WHERErowid='10';

Any mysql gurus who could help?

anyone?