Search is too permissive

[topher1kenobe]

If I search for "hand" I get a photo of a cHANDelier, which doesn't seem right.

[Otto42]

Same for deli. All I wanted was some ham... ​https://wordpress.org/photos/?s=deli

Only allow partial matching at the start of a word, perhaps? Ideas?

[dd32]

Just noting that it appears the Photo directory is using standard WordPress search at present.

This is the pertinent search parts of the WHERE for the above deli example:

WHERE 
  (
    (
      (
        wp_posts.post_title LIKE '%deli%'
      ) 
      OR (
        wp_posts.post_excerpt LIKE '%deli%'
      ) 
      OR (
        wp_term_taxonomy.taxonomy = 'photo_tag' 
        AND wp_terms.name = 'deli'
      ) 
      OR (
        wp_posts.post_content LIKE '%deli%'
      )
    )
  ) 

[coffee2code]

In 12235:

Photo Directory, Search: Limit partial matching of search terms to at least being at the start of a matching term.

Fixes #6569.