Remove HTML-code

Removing/finding HTML-code using regular expressions:

SELECT regexp_replace(name, ‘<.*?>’)  name_without_tags FROM table WHERE regexp_like(name, ‘<.*?>’)