UPDATE post SET pagetext = '[this was a baaad post that contained the word "rapidshare"]' WHERE pagetext LIKE '%rapidshare%';