{"id":513,"date":"2006-06-06T15:53:30","date_gmt":"2006-06-06T19:53:30","guid":{"rendered":"http:\/\/www.uvm.edu\/~waw\/blog\/?p=513"},"modified":"2006-06-06T15:53:30","modified_gmt":"2006-06-06T19:53:30","slug":"landscape-change-project-full-text-search","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2006\/06\/06\/landscape-change-project-full-text-search\/","title":{"rendered":"Landscape Change Project: full text search"},"content":{"rendered":"<p>I have updated the Quick Search button to use mySQL Full text indices. Searches pretty much follow the Google model:<\/p>\n<ul>\n<li>search for<\/li>\n<\/ul>\n<div style=\"margin-left: 40px\">Skiing Stowe<\/p>\n<\/div>\n<p>searches for skiing AND stowe. Normal mysql behavior is to search for skiing OR stowe, so secret + signs are prepended to the words<\/p>\n<ul>\n<li>search for<\/li>\n<\/ul>\n<div style=\"margin-left: 40px\">Stowe -skiing<\/p>\n<\/div>\n<p>searches for Stowe but NOT sking<\/p>\n<ul>\n<li>search for<\/li>\n<\/ul>\n<div style=\"margin-left: 40px\">Mount Mansfield<\/p>\n<\/div>\n<p>searches for words&nbsp; Mount and Mansfield<\/p>\n<ul>\n<li>search for<\/li>\n<\/ul>\n<div style=\"margin-left: 40px\">&quot;Mount Mansfield&quot;<\/p>\n<\/div>\n<p>searches for phrase Mount Mansfield (case insensitive)<\/p>\n<ul>\n<li>search for<\/li>\n<\/ul>\n<div style=\"margin-left: 40px\">Stowe -skiing &quot;Mount Mansfield&quot;<\/p>\n<\/div>\n<p>Searches for the Word Stowe and the phrase &quot;Mount Mansfield &quot; and NOT skiing<\/p>\n<p>The following fields are searched:<\/p>\n<p>FILENAME, OriginalFileName, title, keywords, description, town, county, PHOTOSOURCE, PHOTODATE, PHOTOYEAR, PHOTOGRAPHER, MEDIA, identifier_citation, identifier_other, publisher<\/p>\n<p>There are still some issues in details.php with respect to highlighting search terms. I have no idea what &quot;Refine Results&quot; will do with this.<\/p>\n<p>Other programmers are welcome to investigate, I&#8217;m going to take a break for a day or two and work on some other projects.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <a href=\"https:\/\/blog.uvm.edu\/waw\/2006\/06\/06\/landscape-change-project-full-text-search\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38506,6517],"tags":[],"class_list":["post-513","post","type-post","status-publish","format-standard","hentry","category-landscape-change","category-projects"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/513","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=513"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/513\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=513"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=513"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}