我有以下在java中查询(mysql)的摘录:
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 ");当我将它放在上面的代码中时,需要将MATCH函数(也可能是AGAINST)详细说明我的研究,缺少的参数mysql说,我试图按照下面的方法做,但不起作用:
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 ");我需要把这个函数放在这个查询中MATCH ..