Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unhappy Unanswered: 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 advance

  2. #2
    Join Date
    Nov 2003
    Posts
    3
    the sample string should like this - "<P><STRONG>Access High Resorst<BR>"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •