Posted by fabmo on 11/29/05 16:46

Hello,
sorry for my terrible english, I've got a problem:

in a mysql table like :

id INT(11) auto_increment not null primary key,
tab_title VARCHAR(20),
tab_content BLOB

'tab_content' field may contain html code.

Can I create a SELECT query which finds a text in 'tab_content' field
and excludes html tags?

For example :
if I have to find : FFF
it will find : <b>My name is FFF ...</b>
it won't find : <font color="#FFFFFF">My name is Frank ....</font>

Thanks in advance.

[Back to original message]