Remove HTML-code

Removing/finding HTML-code using regular expressions: SELECT regexp_replace(name, ‘<.*?>’)  name_without_tags FROM table WHERE regexp_like(name, ‘<.*?>’)