title: SQL Query to replace part of HTML (iframe src="http:// to iframe src="://)
body: <p>I have a Joomla 2.5.28 that is now using <code>https</code> instead of <code>http</code>.</p>
  
  <p>Some articles (many) contain embeded videos from Vimeo. </p>
  
  <p>Originally, those videos were embeded using http, so now I have in my database in fields <code>introtext</code> or <code>fulltext</code>, html code like:</p>
  
  <pre><code>&lt;p&gt;Text, etc...&lt;/p&gt;
  &lt;iframe src="http://player.vimeo.com/video/123" width="690" height="518" frameborder="0" webkitAllowFullScreen mozallowfullscreen allowFullScreen&gt;&lt;/iframe&gt;
  &lt;iframe width="690" height="400" frameborder="0" scrolling="no" src="https://skydrive.live.com/embed?cid=xxx&gt;&lt;/iframe&gt;
  &lt;ul&gt;
  &lt;li&gt;
  ...
  </code></pre>
  
  <p>So, how do I build a SQL query to keep the HTML as it is but replace:</p>
  
  <pre><code>&lt;iframe src="http://
  </code></pre>
  
  <p>To:</p>
  
  <pre><code>&lt;iframe src="://
  </code></pre>