• 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?

#1
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.)
 

Brogan

XenForo moderator
Staff member
#2
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.

http://xenforo.com/community/threads/frequently-asked-questions.5183/#post-180445

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.
 

Digital Doctor

Well-known member
#4
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.)
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.
 
#6
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.

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
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...)