开发者

Set match function in a mysql query with Java

I have the following excerpt from a query (mysql) made ​​in java:

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开发者_Python百科 AND ")
          .append("f.fabricante = fp.fabricante AND ")
          .append("p.cod_material = fp.cod_material AND ")
          .append("e.id_extensao = p.id_extensao ");

necessary to put the MATCH function (and perhaps AGAINST) 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:

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 ");

I need to put the function in this query MATCH..

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜