Html – How to query a database field but ignore the HTML markup

html, search, sql

We have a field that contains HTML markup for formatting on the website, but we need to query just the text that should render on screen, not things like CSS tags, tag names, property names, etc.

Is there a way to ignore the markup right in the SQL query or Stored Procedure? If there are ways to do this, will we have performance issues later on?

My guess is that there is some way to use the angle brackets to parse the fields for searchable text.

Best Solution