I have updated the Quick Search button to use mySQL Full text indices. Searches pretty much follow the Google model:
- search for
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
searches for Stowe but NOT sking
- search for
searches for words Mount and Mansfield
- search for
searches for phrase Mount Mansfield (case insensitive)
- search for
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.
