Hi all. I have this problem with replace() function in postgresql. I have some texts in db which contains html tags. When I search for occurence of word "table" in texts my results contains texts which has this word in html tags only. But I don't want search in html tags.
I wrote select with WHERE clausule whiche contains replace function to fix this problem. But it doesn't work. Regular expression in replace function probably doesn't work.
SELECT * FROM textportions WHERE replace(text, '<[^>]*>', '') like '%table%'
The questiuon is: Is replace() function working with regex??
Or what can I do to solve my problem??