How do you remove all integer values in a column?
For example if we have apple234banana, the result will be applebanana.
Thank you.
1
You can use this update statement
UPDATE your_table
SET column_name = REGEXP_REPLACE(column_name, '[0-9]+', '')
1