开发者

Mixing MATCH AGAINST with JOINO in MySQL

Is it possible to expand this query

SELECT id, name, MATCH (name) AGAINST (%s)
AS score FROM mydb.authors WHERE MATCH (name) AGAINST (%s)

by following one?

SELECT authors.id, papers.id FROM `mydb`.`auth2pape开发者_JS百科r`
JOIN `mydb`.`papers` ON `mydb`.`auth2paper`.paper_id = `mydb`.`papers`.id
JOIN `mydb`.`authors` ON `mydb`.`auth2paper`.auth_id = `mydb`.`authors`.id


There is no reason why not. Just use the MATCH in the WHERE as you normally would.

SELECT authors.id, papers.id, MATCH (`mydb`.`authors`.name) AGAINST (%s) Score
FROM `mydb`.`auth2paper`
JOIN `mydb`.`papers` ON `mydb`.`auth2paper`.paper_id = `mydb`.`papers`.id
JOIN `mydb`.`authors` ON `mydb`.`auth2paper`.auth_id = `mydb`.`authors`.id
WHERE MATCH (`mydb`.`authors`.name) AGAINST (%s)
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜