Friday, February 24, 2012

fulltext search HTML problem

Hi,

currently we use text field in table to store HTML, and we use fulltext index to search this field, but we can not always get right results, for example, given text - "<P><STRONG>Access High Resorts<BR>", I can not get result if I search for "Access" or "cce", but if fine if I search for "High" or 'Resor", since I use CONTAINS, and CONTAINS can not search for postfix.

I know I can create another image data type field, and seach will filter HTML tag, but it will take long time to do.

Is there a way I can search postfix or mid-field of word in fulltext search? any idea or suggestion?

Thanks in advancethe sample string should like this - "<P><STRONG>Access High Resorst<BR>"

No comments:

Post a Comment