From: paul
Date: December 18 2005 6:58pm
Subject: svn commit - mysqldoc@docsrva: r590 - in trunk: . refman-4.1 refman-5.0 refman-5.1
List-Archive: http://lists.mysql.com/commits/227
Message-Id: <200512181858.jBIIwtGv001418@docsrva.mysql.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Author: paul
Date: 2005-12-18 19:58:54 +0100 (Sun, 18 Dec 2005)
New Revision: 590

Log:
 r4900@frost:  paul | 2005-12-18 12:58:40 -0600
 Add example from Serg for ~ boolean search operator.


Modified:
   trunk/
   trunk/refman-4.1/functions.xml
   trunk/refman-5.0/functions.xml
   trunk/refman-5.1/functions.xml


Property changes on: trunk
___________________________________________________________________
Name: svk:merge
   - b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4896
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1694
   + b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:4900
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:1694

Modified: trunk/refman-4.1/functions.xml
===================================================================
--- trunk/refman-4.1/functions.xml	2005-12-18 05:24:44 UTC (rev 589)
+++ trunk/refman-4.1/functions.xml	2005-12-18 18:58:54 UTC (rev 590)
@@ -9622,6 +9622,22 @@
 
         <listitem>
           <para>
+            <literal>'+apple ~macintosh'</literal>
+          </para>
+
+          <para>
+            Find rows that contain the word <quote>apple</quote>, but if
+            the row also contains the word <quote>macintosh</quote>,
+            rate it lower than if row does not. This is
+            <quote>softer</quote> than a search for <literal>'+apple
+            -macintosh'</literal>, for which the presence of
+            <quote>macintosh</quote> causes the row not to be returned
+            at all.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <literal>'+apple +(&gt;turnover &lt;strudel)'</literal>
           </para>
 

Modified: trunk/refman-5.0/functions.xml
===================================================================
--- trunk/refman-5.0/functions.xml	2005-12-18 05:24:44 UTC (rev 589)
+++ trunk/refman-5.0/functions.xml	2005-12-18 18:58:54 UTC (rev 590)
@@ -9691,6 +9691,22 @@
 
         <listitem>
           <para>
+            <literal>'+apple ~macintosh'</literal>
+          </para>
+
+          <para>
+            Find rows that contain the word <quote>apple</quote>, but if
+            the row also contains the word <quote>macintosh</quote>,
+            rate it lower than if row does not. This is
+            <quote>softer</quote> than a search for <literal>'+apple
+            -macintosh'</literal>, for which the presence of
+            <quote>macintosh</quote> causes the row not to be returned
+            at all.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <literal>'+apple +(&gt;turnover &lt;strudel)'</literal>
           </para>
 

Modified: trunk/refman-5.1/functions.xml
===================================================================
--- trunk/refman-5.1/functions.xml	2005-12-18 05:24:44 UTC (rev 589)
+++ trunk/refman-5.1/functions.xml	2005-12-18 18:58:54 UTC (rev 590)
@@ -9631,6 +9631,22 @@
 
         <listitem>
           <para>
+            <literal>'+apple ~macintosh'</literal>
+          </para>
+
+          <para>
+            Find rows that contain the word <quote>apple</quote>, but if
+            the row also contains the word <quote>macintosh</quote>,
+            rate it lower than if row does not. This is
+            <quote>softer</quote> than a search for <literal>'+apple
+            -macintosh'</literal>, for which the presence of
+            <quote>macintosh</quote> causes the row not to be returned
+            at all.
+          </para>
+        </listitem>
+
+        <listitem>
+          <para>
             <literal>'+apple +(&gt;turnover &lt;strudel)'</literal>
           </para>