CiberBob Posted December 2, 2021 Posted December 2, 2021 Hello, I am contacting you because I have a cryptocurrency forum and we have a lot of 3 letter words, how can the internal search engine search for 3 letter words? Example: NFT, BTC, ETH .... thank you so much
Dean_ Posted December 2, 2021 Posted December 2, 2021 Like most search engines, you can add quotes to search words directly. So; "NFT" will search the exact phrase. See if it works for you?
Solution Marc Posted December 3, 2021 Solution Posted December 3, 2021 If you are the standard search, you need to be aware that mysql by default is limited to 4 and above chars in searches. So in order to search for 3 letter words, you would need to have your hosting company amend your mysql full text settings. Your hosting company will already be aware, however these are ft_min_word_len and innodb_ft_min_token_size CiberBob, Meddysong and SeNioR- 2 1
Marc Posted December 3, 2021 Posted December 3, 2021 9 minutes ago, CiberBob said: Thank you so much 😉 No problem. Glad you have what you need 🙂 CiberBob 1
CiberBob Posted December 6, 2021 Author Posted December 6, 2021 (edited) Le 12/03/2021 à 09h15, Marc Stridgen a déclaré : Si vous êtes la recherche standard, vous devez savoir que mysql par défaut est limité à 4 caractères et plus dans les recherches. Ainsi, pour rechercher des mots de 3 lettres, vous devez demander à votre société d'hébergement de modifier vos paramètres de texte intégral mysql. Votre hébergeur est déjà au courant, mais il s'agit de ft_min_word_len et innodb_ft_min_token_size Hello, The change has been made and the server has been restarted but I still cannot search for 3 letter words. How to do it please? thank you so much Edited December 6, 2021 by CiberBob
Marc Posted December 6, 2021 Posted December 6, 2021 Have you rebuilt your search index? If not, you would need to do this from System>Search in your Admin CP SeNioR- and CiberBob 1 1
CiberBob Posted December 6, 2021 Author Posted December 6, 2021 Oh yes there it works better thank you very much
Marc Posted December 6, 2021 Posted December 6, 2021 47 minutes ago, CiberBob said: Oh yes there it works better thank you very much No problem at all 🙂 CiberBob 1
Recommended Posts