Searching with stripped HTML tags off

[joon]

where message like '%B%'

The above where clause might mean retrieving records which has the SearchKeyWord "B" in the message field.

Let's suppose the message has HTML Tags inside.

Although it has no "B" in pure text, if it has <Br>,<B>,</B>, or <font color="Blue">, the record will be retrieved by the above where clause.
I like to prevent it.

Can I make the "WHERE clause" retrieve record which has "B" in the pure text?

[Grisu]

What you are looking for is a SQL-function like strip_tags(). A function like this does not belong to the SQL-standard until now as far as I know. So there are three alternatives:

1.) You make a separate field that contains the pure text. This you can do always when you create or update a record or you put it in a separate table and select from this table.

2.) You re-check all results of the SQL-query again with PHP.

3.) You build your own function for the DBS. For MySQL this works with CREATE FUNCTION.

Maybe one solution already helps you.

Grisu

[joon]

Originally posted by Grisu
You build your own function for the DBS. For MySQL this works with CREATE FUNCTION.
Grisu [/B]

Can You tell me how I can create my own function ?

Where can I read about it?

[Grisu]

there is something written in the documentation to MySQL. Have a search for CREATE FUNCTION. I never did it so I do not know more.

Grisu