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?