Extract All Links table
LIKE '%http%www%domain.com%'


will find the lines.  But SQL cannot extract the desired part.  Instead, do the extraction in your application code.

OR...

Redesign your schema to already have the URL in a separate column.