Cool, thanks Gizmo.

I'm about to run the code I mentioned above on our DB.

I did a quick dump/load into my test system and it appears that it ran OK (and really not as long as I would have expected:)

Quote
mysql> update ubbt_POSTS set POST_BODY = replace(POST_BODY, '[code they inserted]', '');
Query OK, 789195 rows affected (3 min 25.85 sec)
Rows matched: 789343 Changed: 789195 Warnings: 0

mysql> select count(*) from ubbt_POSTS where POST_BODY LIKE '%<iframe%' or POST_BODY LIKE '%<script%'
-> ;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (13.15 sec)

Unfortunately, my test(home) server is probably faster than the "production" server, but even 5 minutes ain't bad for 789k rows IMHO.

Here goes nothing.

Last edited by bakerzdosen; 08/26/2012 6:16 PM.
bmwsporttouring.com