开发者

Set match function in a mysql query with Java

开发者 https://www.devze.com 2023-04-08 20:14 出处:网络
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 \")

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

精彩评论

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