title: Trick to use variable in match against mysql
body: <p>Please first read my question,and then you will find out it is not a duplicate of other question.</p>
  
  <p>I'm using sphinx search for 98% of search,but need to use match against for just one query.</p>
  
  <p>As we know from mysql documentation that AGAINST only takes string.<code>The search string must be a literal string, not a variable or a column name.</code></p>
  
  <p>But I have found this link <a href="http://bugs.mysql.com/bug.php?id=66573" rel="nofollow">http://bugs.mysql.com/bug.php?id=66573</a> ,which says it is possible.But I'm not sure how to use that in my case.</p>
  
  <p>Here is my code</p>
  
  <pre><code>    $sqli="SELECT busi_title,category FROM `user`.`user_det`";
      $queryi=mysqli_query($connecti,$sqli);
          if(mysqli_num_rows($queryi)&gt;0){
              while($rowi=mysqli_fetch_assoc($queryi)){
                $busi_title=$rowi['busi_title'];
                $category=$rowi['category'];
              }
  
          }else{
              echo "OH NO";
           }
  
  $sqlj="SELECT * FROM `user`.`user_det` WHERE MATCH(student) AGAINST('$busi_title','$category')";
  $queryj=mysqli_query($connecti,$sqlj);
       if(mysqli_num_rows($queryj)&gt;0){
          ..............................
          ..............................
       }else{  
          foreach ( $res["matches"] as $doc =&gt; $docinfo ) {
           ................................
            ...............................
           }
        }
  </code></pre>
  
  <p><code>MATCH() AGAINST()</code> is giving error,as it supposed to be.How to use that trick of that link in this case.I don't know the use of <code>@word:=</code> of that link.</p>
  
  <p>Thanks in advance.</p>