title: Set match function in a mysql query with Java
body: <p>I have the following excerpt from a query (mysql) made ​​in java:</p>
  
  <pre><code>queryGeral.append("FROM product p, fabricante_product fp, fabricante f, extensao e,  product_autor pa ")
            .append(" WHERE ")
            .append("a.nome like ? AND ")
            .append("p.cod_material = pa.cod_material AND ")
            .append("f.fabricante = fp.fabricante AND ")
            .append("p.cod_material = fp.cod_material AND ")
            .append("e.id_extensao = p.id_extensao ");
  </code></pre>
  
  <p>necessary to put the <code>MATCH</code> function (and perhaps <code>AGAINST</code>) to detail my research when I put it in the code above, the missing parameters mysql says, I'm trying to do like this below, but does not work:</p>
  
  <pre><code>queryGeral.append("FROM product p, fabricante_product fp, fabricante f, extensao e,  product_autor pa ")
            .append(" WHERE ")
            .append("MATCH p.name AND ")
            .append("a.nome like ? AND ")
            .append("p.cod_material = pa.cod_material AND ")
            .append("f.fabricante = fp.fabricante AND ")
            .append("p.cod_material = fp.cod_material AND ")
            .append("e.id_extensao = p.id_extensao ");
  </code></pre>
  
  <p>I need to put the function in this query <code>MATCH</code>..</p>