UPDATE `post` SET `pagetext` = replace(pagetext,'asdasdsd', 'abcabc') WHERE pagetext LIKE '%asdasdsd%'