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
..
精彩评论