mysql remove string with some pattern

Question

my question can be simply described as one line:

remove string with this pattern from one column in a table: width="480" height="70"

I have searched everywhere, no solution. Hope stackoverflow can help me finally.

Pls share what you have tried. – Shadow Nov 02 '17 at 15:22 — Shadow, Nov 02 '17 at 15:22
mysql does not support regex replacement. – Bohemian Nov 02 '17 at 15:23 — Bohemian, Nov 02 '17 at 15:23

SEarle1986 · Answer 1 · 2017-11-02T15:26:40.317

0

UPDATE your_table
SET    your_column = REPLACE(your_column,'width="480" height="70"','')

edited Nov 02 '17 at 15:26

answered Nov 02 '17 at 15:21

SEarle1986

1 Answers1