SELECT ID, 
       SUBSTRING(  wp.post_content , LOCATE(  '<pre>',  `post_content` ))
FROM  `wp_posts` as wp
WHERE
`post_content` like '%</p>%' AND ID=99

UPDATE  `wp_posts`
      SET  `post_content = SUBSTRING( `post_content` , LOCATE(  '<pre>',  `post_content` ))
WHERE `post_content` like '%</p>%'