MySQL: Mass Replace using a regex?

Question

I'm trying to replace all instances of   with a simple space EXCEPT if it's surrounded by DIV tags. I've tried tinkering with the NOT REGEXP and NOT RLIKE within the replace query, like this:

UPDATE table SET column = replace(column,NOT REGEXP '>&#160;<',' ');

But it gives a syntax error. Anyone have any suggestions?

Diego · Accepted Answer · 2012-02-25 01:55:25Z

1

How about three separate updates...

UPDATE table SET column = replace(column, '> <', '%%LOL$$');
UPDATE table SET column = replace(column, ' ', ' ');
UPDATE table SET column = replace(column, '%%LOL$$', '> <');

answered Feb 25, 2012 at 1:55

Diego

18.5k5 gold badges67 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bruno Silva · Accepted Answer · 2012-02-25 01:21:17Z

0

Something like this should work:

UPDATE table SET column = REPLACE(column, '&#160;', ' ') WHERE column NOT LIKE '%div>&#160;</%'

answered Feb 25, 2012 at 1:21

Bruno Silva

3,09720 silver badges20 bronze badges

1 Comment

J. Scott Elblein Over a year ago

I tried this and it said over 8K rows affected, and when I went in and looked at one of them it all looked the same as before. eek lol

Collectives™ on Stack Overflow

MySQL: Mass Replace using a regex?

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related