Manipulating post table with phpmyadmin

[0ptima]

Somehow a member's account has been hacked and hundreds of posts have edited with links to spam.

I would like to run a mysql query on the post table to remove the spam links. I have come up with the following query

update post set pagetext = replace(pagetext,'\n________\nspammer text','')
where `userid` = 123

This seems to do the trick and I tested it on a local installation. I was would like to know if there are any consequences of running such a query on my real forum and if there is a better way of deleting the spam links. Thanks.