I need a code for MySQL.

[Themoose]

Dear friends, we have encountered an issue regarding the entry of prices for products saved in Turkish Lira as the unit price. To resolve this issue, I am looking for a MySQL code that can divide all prices in the price field by the current exchange rate, for example, 3.50, and replace the TL value with the EURO value. I have searched but couldn't find such a code. Another approach could be splitting a value in another column and transferring it to a different column in the Product ID, then copying the newly derived values from EURO to TL if the IDs match. Also, the EURO value is stored in a separate column, and if it is 0, then it is considered as 1. This information is used in PHP coding to determine the currency type.