title: How do i extract one or multiple URLs from a text (NVARCHAR(MAX)) column
body: <p>I have a data column in my table, and in this column there can be zero, one or multiple URLs along other text on each row. I would like to extract these URLs into a new dataset containing only these.</p>
  
  <p>Why? Because I want to add some of these URLs to a block list in my DB to prevent spam.</p>
  
  <p>For example, I have this text in the data column:</p>
  
  <pre><code>hmaruqbtufcvdlfu, &lt;a href="httx://portugal-forex.com/"&gt;Day forex signal strategy trading&lt;/a&gt;, KzxiIIO, [url=httx://portugal-forex.com/]Forex Broker[/url], mtNZQDi, httx://portugal-forex.com/ The best forex broker, IBWlBzg, &lt;a href="httx://phen375treatment.com/"&gt;Avantage inconveniant phen 375&lt;/a&gt;, ApEuXTp, [url=httx://phen375treatment.com/]Phen375[/url], QDVLpSn, httx://phen375treatment.com/ Where to buy phen 375, Fnwpugj, &lt;a href="httx://priligy2000.org/"&gt;Priligy t&lt;/a&gt;, zwRZhIC, [url=httx://priligy2000.org/]Order priligy[/url], FBgSaWs, httx://priligy2000.org/ Priligy buy online, FsemWnW, &lt;a href="httx://ossorio.org/"&gt;Online Casino&lt;/a&gt;, aOBtTaK, [url=httx://ossorio.org/]Online Casino[/url], oMMMacf, httx://ossorio.org/ Free online casino bounuses, occFLyZ, &lt;a href="httx://paroxetine247.com/"&gt;Paroxetine adema&lt;/a&gt;, xvrIdnq, [url=httx://paroxetine247.com/]Paroxetine depression[/url], MLSRAXX, httx://paroxetine247.com/ Paroxetine dark skin, GLYTcZY, &lt;a href="httx://resolvedisputes.org/"&gt;Fioricet prescription online&lt;/a&gt;, PmEMaMA, [url=httx://resolvedisputes.org/]Fioricet wcodiene for headache[/url], vPlKLhq, httx://resolvedisputes.org/ Online pharmacy fioricet, fxfhRcV.
  </code></pre>
  
  <p>Then I want all URLs in the text:</p>
  
  <pre><code>httx://portugal-forex.com/
  httx://phen375treatment.com/
  httx://priligy2000.org/
  And so on.
  </code></pre>
  
  <p>I really dont know where to start the do this in SQL.</p>