#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    95
    Rep Power
    12

    Question Indexing service MATCHES not working


    I am trying to look for a specific phrase in downloadable documents on my website. I have stored the documents in a single folder (for ease) and I am using the following to Pull out some results:
    Code:
    SELECT filename, vpath, characterization, DocTitle, DocAuthor, DocLastSavedTm, HitCount, create from scope() WHERE freetext (Contents, 'big brown bear')
    This works ok but pulls out results there just brown is in the contents as opposed to that specific phrase.
    I have tried the following:
    Code:
    SELECT filename, vpath, characterization, DocTitle, DocAuthor, DocLastSavedTm, HitCount, create from scope() WHERE MATCHES (Contents, 'big brown bear')
    But this returns no results.
    I am trawling just a specific folder and also just .doc and .pdf files but I have not included this in my SQL for ease.
    Can anybody quide me in the correct SQL to search for exact phrases within the Contents of the documents.

    Thanks in advance
    Last edited by decker27; April 12th, 2013 at 04:50 AM. Reason: Found out how to pull out file last modified date so no longer need to know

IMN logo majestic logo threadwatch logo seochat tools logo