Change search character limit

[Geoffrey]

Is there a way for me to change the minimum character limit (decrease it actually) for forum searches?

 

[craigiri]

It's done in mysql and/or in the ES add-on if you use it.

Looks like you can do it globally or in the cnf file....
http://www.milestree.com/php/mysql-boolean-search-fixing-stop-words-character-limit

FT_MIN_WORD_LEN
http://www.electrictoolbox.com/mysql-full-text-index-word-length/

You also will have to rebuild the search index - I'm not sure if you can just do that in the ACP or if you have to do it in mysql.

 

[Geoffrey]

What SQL table do I edit and how? I've never touched MySQL...

 

[Walter]

No table - read the first link he posted and you will read that you have to change the Mysql configuration file on the server -but please, this should do your admin.

 

[craigiri]

Yes, have your admin do it - as I mentioned, you may have to redo your search index in the ACP afterwards so the new search applies to existing posts!

My advice, if you have a big board, is to instead use the Elasticsearch add-on ($50, I think) available here. Get Slavik to install it for you. That's what I use and I have search on 2 characters.

 

[Geoffrey]

I am the admin... -_-

I just won't bother with it, topic solved.