king-net
شنبه 09 مهر 1390, 17:46 عصر
درود .
دوستان دو روز که با این 3 کارکتر به مشکل خوردم .
من برای جستجوی سایتم از فول تکست استفاده کردم ،اما 4 حرف باشه جستجو میکنه اما اگه 3 یا 2 یا 1 حرف باشه نتیجه ای رو برنمیگردونه :لبخندساده:
تو سایت mysql هم اینو پیدا کردم :
If you are familiar with full text searching in MySQL, you will be surprised to know that MySQL doesn’t index words containing 3 or less characters by default. Searching such words ends up with no result. I am sure sometime you also suffered from the same problem. If you are not familiar with this default behavior of MySQL you may spend hours after hours trying to find out what went wrong. Well, here is the solution for you :D There is a system option named “ft_min_word_len” by which you can define the minimum length of words to be indexed. You need to set value to this configuration directive in your MySQL configuration file which is found under “/etc/mysql” or “/etc”. In windows you can look under windows directory or MySQL home folder. You need to set this value under [mysqld] section. [mysqld]ft_min_word_len=3 There is also a handy method if you don’t want to change in your configuration file. Just start your mysql daemon with the following command mysqld --ft_min_word_len=3 You may also need to rebuild your index. Now you can search words with 3 characters in your full text queries.
اما دستوری که داده معلوم نیست باید کجا گذاشت :افسرده: تو my.ini گذاشتم کار نکرد تو mysqld.exe هم اومدم بزارم که اونم نمیشه بش فرمان بدی :گیج:
دوستان دو روز که با این 3 کارکتر به مشکل خوردم .
من برای جستجوی سایتم از فول تکست استفاده کردم ،اما 4 حرف باشه جستجو میکنه اما اگه 3 یا 2 یا 1 حرف باشه نتیجه ای رو برنمیگردونه :لبخندساده:
تو سایت mysql هم اینو پیدا کردم :
If you are familiar with full text searching in MySQL, you will be surprised to know that MySQL doesn’t index words containing 3 or less characters by default. Searching such words ends up with no result. I am sure sometime you also suffered from the same problem. If you are not familiar with this default behavior of MySQL you may spend hours after hours trying to find out what went wrong. Well, here is the solution for you :D There is a system option named “ft_min_word_len” by which you can define the minimum length of words to be indexed. You need to set value to this configuration directive in your MySQL configuration file which is found under “/etc/mysql” or “/etc”. In windows you can look under windows directory or MySQL home folder. You need to set this value under [mysqld] section. [mysqld]ft_min_word_len=3 There is also a handy method if you don’t want to change in your configuration file. Just start your mysql daemon with the following command mysqld --ft_min_word_len=3 You may also need to rebuild your index. Now you can search words with 3 characters in your full text queries.
اما دستوری که داده معلوم نیست باید کجا گذاشت :افسرده: تو my.ini گذاشتم کار نکرد تو mysqld.exe هم اومدم بزارم که اونم نمیشه بش فرمان بدی :گیج: