Example :
I have stored below html tag as one field in data extension. I need to retrieve the href url from this. How to retrieve this ?

HTML : 



<h1> The a element </h1>

<a href="https://www.w3schools.com"   Visit W3Schools.com!<a>