Mysql what query to remove the character "-" from the column?

Question

MySQL

Hello!
The "oc_product_option_value" table has a "price" column and the values ​​are -45932 and so on. Prompt what request to remove the character "-" from the column?
And one more question: It is
necessary to delete all rows in the table that have the value "2" in the "language_id" column.
What query can do this?

Answer 1

UPDATE oc_product_option_value
SET price= REPLACE(price, '-', '');
DELETE FROM table_name WHERE language_id = 2

Answer 2

If type is numeric then ABS(price) if type is string then REPLACE(price, '-', '')