"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]