Landscape Change Project

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);

About Wesley Wright

Born on a mountain top near New York City, Craziest state in the land of the pretty. Raised in the woods so's he knew every tree, Killed him a bear when he was only three.
This entry was posted in Landscape Change, Projects. Bookmark the permalink.

Leave a Reply