For those reading this, I think you want to add a % to the end of that select statement for it to work:

eg: select count(*) from ubbt_POSTS where POST_BODY LIKE '%<iframe%' or POST_BODY LIKE '%<script%'


Anybody want to give me a primer on mysql replace? Sweeping changes like that make me nervous. Especially with statements like this in the docs:
Quote
Currently, you cannot replace into a table and select from the same table in a subquery.

Is it really as simple as "update ubbt_POSTS set POST_BODY = replace(POST_BODY, '<script src=http://[path/to/inserted/jsfile]></script>', '');"?


bmwsporttouring.com