1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Search for less than 3 characters words?

Discussion in 'General XenForo Discussion and Feedback' started by zOrg, Sep 25, 2011.

  1. zOrg

    zOrg Member

    Can I search in the nearly released v1.1 for 2 characters words (trademarks, etc.)?
    (This feature is one of the most important to me.)
  2. Brogan

    Brogan XenForo Moderator Staff Member

    This is a MySQL limitation.

    Why can't I search for words with 3 characters or less?
    This is a limitation of the MySQL Full Text search function. Find more information on the MySQL site.

    Why can't I search for certain words?
    The MySQL search function has what are called stopwords, which are typically common words, and are excluded from searches. Find more information on the MySQL site.


    There are many threads on this subject: http://xenforo.com/community/search/1340516/?q=search three letter words&t=post&o=date

    You also posted this question already on an existing thread about it: http://xenforo.com/community/thread...-for-the-xf-company-forums.18970/#post-259207

    You can change the behaviour on your own installation.
  3. TheComputerGuy

    TheComputerGuy Active Member

    Plus there is a big board search coming as well.

    I can't wait to hear more about in the coming months!
  4. Digital Doctor

    Digital Doctor Well-Known Member

    One workaround might be to convert all searches to wildcard searches.

    four letter search .. leave it.
    three letter search .. php* or *php*
    two letter search .. *xf*

    You would append the asterisks as needed.
    This would have to be a mod.
  5. Digital Doctor

    Digital Doctor Well-Known Member

    of course other forum software has gotten around this.
    so it's not as much as a MySQL limitation, it is a MySQL limitation that is exposed by how xenforo does it searches.
    The wildcard searches is a way to get around it.
  6. zOrg

    zOrg Member

    Yes, I know this is a MySQL limitation, but in IPB admin you can specify the minimum number of chars - with a simple textbox option...
    (Sorry for the "duplicated" question, but I must choose forum soft within a week - I'd like to install XF, but the search for 2 chars is a must for my community (most of the trademarks, model names, etc. only 2 chars in bicycle industry...)
  7. Brogan

    Brogan XenForo Moderator Staff Member

  8. zOrg

    zOrg Member

    Sure, thank so much!

Share This Page