Because of an autoblog plugin , My Wordpress site has got junk text in every post ! The text format is as below .. funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-41-2/" rel="attachment wp-att-3846"> Almost Every post has the above text with the same format but different text and no ... some more example below ... Is here any mysql command with which i can delete all this junk text from all my post .... as deleting one by one is not possible ! Many Thanks in Advance ! funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-42-4/" rel="attachment wp-att-3847"> funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-46-3/" rel="attachment wp-att-3848"> funny-pictures/funny-pictures-of-the-day-30-pics/attachment/funny-pictures-48-2/" rel="attachment wp-att-3849">
I'd probably write a custom script/plugin to do it rather than try to do it with mysql - but I bet the gurus will tell you there is a way!