1. You need Untappd for Business. Get a demo, get a $25 gift card. It's that easy.
    Dismiss Notice

MySQL(?) search limitations

Help Discussion in 'BeerAdvocate Talk' started by babaracas, Apr 18, 2014.

Thread Status:
Not open for further replies.
  1. babaracas

    babaracas Initiate (0) Jan 30, 2008 Florida

    Hey, 2 letter search terms are ignored, e.g. Stone Go To should be an exact match to a beer in the database but results in no relevant results. Understand that MySQL ignores terms < 3 letters, but you're using something bigger and better, right?
     
    #1 babaracas, Apr 18, 2014
    ivorycannon likes this.
  2. Todd

    Todd Founder (13,506) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah Trader

    We're currently using full-text, but that's going to change. We outgrew it long ago, and we need to address it.
     
    #2 Todd, Apr 18, 2014
  3. 01001111

    01001111 Initiate (0) May 12, 2008 California

    Go and To are common stop words. They're probably being stripped out by the analyzer on storage and/or search in whatever search application the site uses.
     
    #3 01001111, Apr 18, 2014
  4. Todd

    Todd Founder (13,506) Aug 23, 1996 Finland
    STAFF Mod Team Society Pooh-Bah Trader

    Not a question, they are. We're looking forward to offering everyone a better search.
     
    #4 Todd, Apr 18, 2014
Thread Status:
Not open for further replies.