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