title: How to update title of posts?
body: <p>I am using phpmyadmin</p>
  
  <p>In every title of post contains "In x" (x is a number in the range 1 to 1000)</p>
  
  <p>Example:</p>
  
  <pre><code> In 434 Hello everybody ----&gt; remove "In 434" -----&gt; Hello everybody
   In 62 Hi everybody     ----&gt; remove "In 62" ------&gt; Hi everybody
   In 2 I am newmember    ----&gt; remove "in 2"  ------&gt; I am newmember
  </code></pre>
  
  <p>How to remove "In x" with sql queries ?</p>
  
  <p>This is my code</p>
  
  <pre><code>SELECT wp_posts.post_title FROM wp_posts Where wp_posts.post_status = 'publish'
  $result = preg_replace('/In \d+ /','',$title);
  UPDATE wp_post SET post_content = $result
  </code></pre>
  
  <p>But is says an error </p>
  
  <blockquote>
    <p>"#1064 - You have an error in your SQL syntax; check the manual that
    corresponds to your MySQL server version for the right syntax to use
    near '$result = preg_replace('/In \d+ /','',$title)' at line 2"</p>
  </blockquote>
  
  <p>Thank you very much ! Sorry for my bad English !</p>