April 11th, 2013, 09:29 AM
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:
This works ok but pulls out results there just brown is in the contents as opposed to that specific phrase.
SELECT filename, vpath, characterization, DocTitle, DocAuthor, DocLastSavedTm, HitCount, create from scope() WHERE freetext (Contents, 'big brown bear')
I have tried the following:
But this returns no results.
SELECT filename, vpath, characterization, DocTitle, DocAuthor, DocLastSavedTm, HitCount, create from scope() WHERE MATCHES (Contents, 'big brown bear')
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 03:50 AM.
Reason: Found out how to pull out file last modified date so no longer need to know