[plug] Stripping out Markups in SQL

[J Michael Gilks]

On Tue, 17 Sep 2002 11:08, Trevor Phillips wrote:
Have taken a bit more of a look at the SQL standard and I think the function 
you need is not native to SQL, but rather an implementation of the database 
you are using.
If you let us know the particular datbase an answer may be forthcoming.
Love
Mike.
> On Saturday 14 September 2002 17:19, Lyndon Kroker wrote:
> > You may want to consider the use of PHP as there is a custom function for
> > this.  PHP can be imbedded into the text of an html document if required.
> >
> > The function is called strip_tags(). Here is an example:
> >
> > $string = strip_tags($string, '<a><b><i><u>');
>
> I know how to do it in any number of languages, but I really need to do it
> in the SQL query itself, since I both sort and filter using a Markup-less
> version of a text field.
>
> Sure, I could just get every match, and filter in code, but that would be
> very inefficient.