back in the saddle. Added a fulltext index to database table:
create fulltext index gclp_full_text on VTLANDSCAPEDB (FILENAME,OriginalFileName,Title, KEYWORDCAT, LONGDESC, TOWN, COUNTY, PHOTOSOURCE, PHOTOGRAPHER,MEDIA, title_alternative, identifier_citation, identifier_other, publisher);
Which allows stuff like this
select FILENAME,Title,LONGDESC,TOWN from VTLANDSCAPEDB where match (FILENAME, OriginalFileName, Title, KEYWORDCAT, LONGDESC,TOWN, COUNTY, PHOTOSOURCE, PHOTOGRAPHER, MEDIA, title_alternative, identifier_citation, identifier_other, publisher) against (‘+ski* +stowe -mansfield’ IN BOOLEAN MODE);
