title: Is it possible to in Mysql Replace the Link and make it target blank?
body: <p>I have our database table column named description and in this column have around 1000 row. Each row can contain more than one link. For example:</p>
  <pre><code>Some description text
  &lt;a href=&quot;example11.com&quot;&gt;Example 11&lt;/a&gt;
  description text is continue
  &lt;a href=&quot;example22.com&quot;&gt;Example 22&lt;/a&gt;
  more description text
  </code></pre>
  <p>Can i update all links and add target blank. In this example text should changed like:</p>
  <pre><code>Some description text
  &lt;a href=&quot;example11.com&quot; target=&quot;_blank&quot;&gt;Example 11&lt;/a&gt;
  description text is continue
  &lt;a href=&quot;example22.com&quot; target=&quot;_blank&quot;&gt;Example 22&lt;/a&gt;
  more description text
  </code></pre>
  <p>The summary is want to change links and add target blank.</p>
  <pre><code>&lt;a href=&quot;example11.com&quot;&gt;Example 11&lt;/a&gt; 
  </code></pre>
  <p>to</p>
  <pre><code>&lt;a href=&quot;example11.com&quot; target=&quot;_blank&quot;&gt;Example 11&lt;/a&gt;
  </code></pre>