Mysql instruction to populate new price column?

Hi,

I recently intsalled Dual Price addon and now I have in the table "products" a new columns "products_price_w" with all rows set to 0.
I'd like to populate through mysql qith a SQL instruction this colums setting the value of "products_price_w" the 80% of the value of the column "product_price".

How could I do that?

Thnak you

Might be easiest to use a plugin easy populate
https://www.zen-cart.com/downloads.php?do=file&id=868

kobra:

Might be easiest to use a plugin easy populate
https://www.zen-cart.com/downloads.php?do=file&id=868

As that version hasn't been updated to be compatible with the lastest ZC version and that your site is still using an old version of ZC that really should be upgraded, might I suggest a version of EasyPopulate (EP4) that covers all of this: https://www.zen-cart.com/showthread.php?200407-Edit-Orders-v4-0-Support-Thread
That way when/if the site is upgraded, there is no relearning how to use the tool for the most part.