UPDATE ipb_forums_posts SET post = REPLACE(post,'http://hoitajat.net/foorumi/public/style_emoticons/default/','http://hoitajat.net/public/style_emoticons/default/');