开发者

Mixing MATCH AGAINST with JOINO in MySQL

开发者 https://www.devze.com 2023-02-21 00:31 出处:网络
Is it possible to expand this query SELECT id, name, MATCH (name) AGAINST (%s) AS score FROM mydb.authors WHERE MATCH (name) AGAINST (%s)

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

精彩评论

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