Help with SQL query

Question

SQL

There is a table "jos_vm_product_price" and in it a column "product_currency".
You need to change all the values ​​in the column from "RUB" to "UAH" (an unfortunate mistake was made during import)

Help, good habralyudi! Thanks in advance!

Answer 1

UPDATE jos_vm_product_price SET 'product_currency'=UAH WHERE 'product_currency'=RUB
?
Bd what is it?