Landscape Change Project: full text search

I have updated the Quick Search button to use mySQL Full text indices. Searches pretty much follow the Google model:

  • search for
Skiing Stowe

searches for skiing AND stowe. Normal mysql behavior is to search for skiing OR stowe, so secret + signs are prepended to the words

  • search for
Stowe -skiing

searches for Stowe but NOT sking

  • search for
Mount Mansfield

searches for words  Mount and Mansfield

  • search for
"Mount Mansfield"

searches for phrase Mount Mansfield (case insensitive)

  • search for
Stowe -skiing "Mount Mansfield"

Searches for the Word Stowe and the phrase "Mount Mansfield " and NOT skiing

The following fields are searched:

FILENAME, OriginalFileName, title, keywords, description, town, county, PHOTOSOURCE, PHOTODATE, PHOTOYEAR, PHOTOGRAPHER, MEDIA, identifier_citation, identifier_other, publisher

There are still some issues in details.php with respect to highlighting search terms. I have no idea what "Refine Results" will do with this.

Other programmers are welcome to investigate, I’m going to take a break for a day or two and work on some other projects.

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