Select from an XML the img src

img_url_select.sql

select id, url from 
(
        select id, array_to_string(regexp_matches(possible, 'src=[\s\\]*"(https?:\/\/.*)"', 'g'), ',') as url
        from (
                select id, array_to_string(regexp_matches(xml::text , '(<img .*?>)', 'g'), ',') as possible from victorious_squirrel_widgets 
                where xml::text ~ '(<img .*?>)'
        ) as foo
) as foo2
where url not like '%URL_NOT_NEEDED%'
order by id