title: How to mass add text to existing content via single formula
body: <p>I currently have an existing Wordpress directory website consisting of 20K city posts. I would like to update the first line of each post to include some text and an image. Each post should have its own unique image.</p>
  
  <p>I am looking for a way to mass enter this into the database.</p>
  
  <p>Tried using a few plugins but none are doing this effectively.</p>
  
  <p>The mysql database has a column called "post_name" which has the city info for each post in "city-state" format. There is also the post title under "post_title" which could be useful for the image alt text. I would like to tap into this to point to the specific city images.</p>
  
  <p>For example:</p>
  
  <pre><code>&lt;img src="/city-state.gif"&gt;Post Title&lt;/ &gt;
  </code></pre>
  
  <p>The content for the post sits in "post_content."</p>
  
  <p>So ideally, I would like to create some code that adds this new content to all "post_content" cells from by using "post_name" so URLs are entered in based on that.</p>
  
  <p>Example:</p>
  
  <p>New static text that won't change for any posts.</p>
  
  <pre><code>&lt;img src="/'post_name'.gif"&gt;'post_title'&lt;/ &gt;
  </code></pre>
  
  <p>Is something like this possible?</p>