Re: ft_boolean_default
Hi! On Feb 13, Heath, Brad wrote: Is this a legitimate variable? It seems like it'd be useful, but when I tried it (on 4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know what's going on? When it was added there was not possible to have a --server_variable that takes a string as a value. Now it's possible, but 4.0 is stable, so I cannot make ft_boolean_syntax a changeable variable there. But I just pushed this to 4.1. Should be in 4.1.2 Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ft_boolean_default
It would be good as spaces between words are taking OR as the default, i ave devised a system where the user selects the AND in the dropdown and if they select that is will add a + to every word. Hi! On Feb 13, Heath, Brad wrote: Is this a legitimate variable? It seems like it'd be useful, but when I tried it (on 4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know what's going on? When it was added there was not possible to have a --server_variable that takes a string as a value. Now it's possible, but 4.0 is stable, so I cannot make ft_boolean_syntax a changeable variable there. But I just pushed this to 4.1. Should be in 4.1.2 Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ft_boolean_default
Is this a legitimate variable? It seems like it'd be useful, but when I tried it (on 4.0.12-nt and 4.0.17-nt) it didn't work. Anybody know what's going on? Brad [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ft_boolean_default='AND'
electroteque [EMAIL PROTECTED] wrote: hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words There was no ft_boolean_default variable. something1 something2 something3 something4 it will get either exact matches notice the space if i try something1 something2 + something3 something4 doesnt work There shouldn't be a space between + and . SELECT .. FROM .. WHERE .. MATCH(..) AGAINST('+something1 something2 +somethin3 something4' IN BOOLEAN MODE); if i try something1 something2+something3 something4 works without spaces this is a really unfriendly syntax for not technical users , how can i make this search more friendly and make it default to AND ?? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ft_boolean_default='AND'
Hi! On Jun 02, Egor Egorov wrote: electroteque [EMAIL PROTECTED] wrote: hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words There was no ft_boolean_default variable. Still it's possible to make boolean search to do AND by default. There is ft_boolean_syntax variable, it specifies that '+' means AND and space ' ' means OR. You can change it to be other way around. Unfortunately to change this variable one have to rebuild MySQL. See http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: ft_boolean_default='AND'
myisam/ft_static.c'. so i have to edit this and recompile ? what a pain in the ass , i'll have to try and format it then -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 12:53 AM To: Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: ft_boolean_default='AND' Hi! On Jun 02, Egor Egorov wrote: electroteque [EMAIL PROTECTED] wrote: hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words There was no ft_boolean_default variable. Still it's possible to make boolean search to do AND by default. There is ft_boolean_syntax variable, it specifies that '+' means AND and space ' ' means OR. You can change it to be other way around. Unfortunately to change this variable one have to rebuild MySQL. See http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ft_boolean_default='AND'
No swearing please, we are not on holiday ;-) Best regards Nils Valentin 2003 6 3 07:14electroteque : myisam/ft_static.c'. so i have to edit this and recompile ? what a pain in the ass , i'll have to try and format it then -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 12:53 AM To: Egor Egorov Cc: [EMAIL PROTECTED] Subject: Re: ft_boolean_default='AND' Hi! On Jun 02, Egor Egorov wrote: electroteque [EMAIL PROTECTED] wrote: hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words There was no ft_boolean_default variable. Still it's possible to make boolean search to do AND by default. There is ft_boolean_syntax variable, it specifies that '+' means AND and space ' ' means OR. You can change it to be other way around. Unfortunately to change this variable one have to rebuild MySQL. See http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ft_boolean_default='AND'
hi guys , i was wondering if this variable , is available for 4.0.12 ? we tried to make it work but mysql would not start , if this is still not available , what are the best ways for me to try and format a search say for instance currently if i search for two words something1 something2 something3 something4 it will get either exact matches notice the space if i try something1 something2 + something3 something4 doesnt work if i try something1 something2+something3 something4 works without spaces this is a really unfriendly syntax for not technical users , how can i make this search more friendly and make it default to AND ?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]