移行の時に変換していれば良かったんだけど、面倒でサボっていたのですよね。そんなわけで今更変換してみる。
update `wp01_posts` set post_content=replace(post_content,'[:ぎょ:]',' 8-O');
update `wp01_posts` set post_content=replace(post_content,'[:はうー:]',' :(');
update `wp01_posts` set post_content=replace(post_content,'[:ぽっ:]',' :redface:');
update `wp01_posts` set post_content=replace(post_content,'[:きゅー:]',' :?');
update `wp01_posts` set post_content=replace(post_content,'[:あうっ:]',' :x');
update `wp01_posts` set post_content=replace(post_content,'[:にひひ:]',' :)');
update `wp01_posts` set post_content=replace(post_content,'[:にかっ:]',' :mrgreen:');
update `wp01_posts` set post_content=replace(post_content,'[:しょぼん:]',' :cry:');
update `wp01_posts` set post_content=replace(post_content,'[:汗:]',' :(');
update `wp01_posts` set post_content=replace(post_content,'[:にぱっ:]',' :lol:');
update `wp01_posts` set post_content=replace(post_content,'[:がーん:]',' :cry:');
update `wp01_posts` set post_content=replace(post_content,'[:てへっ:]',' ;)');
update `wp01_posts` set post_content=replace(post_content,'[:にこっ:]',' :P');
update `wp01_posts` set post_content=replace(post_content,'[:ぽわわ:]',' :redface:');
update `wp01_posts` set post_content=replace(post_content,'[:しくしく:]',' :cry:');
とりあえずこんな感じのSQLを流して終了。