By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| REGEXP_REPLACE(TEXT,'^(.*<A[^>]+)GROUP(A>.*)$','\1\2',1,0,'I') |
|---|
| <a href Part of the technical Network Group www.tech.com/sites/ hh a> group |
| <a href mean www.tech.technical Network a> |
| www.tech.tech///technical <a href Networka> |