Sphinx. How to give weight to some words in a query?

Question

Sphinx

I display related posts and make it a query

SELECT id, WEIGHT() as relevance FROM posts 
WHERE MATCH('(@content world|peace|leo)') 
ORDER BY relevance DESC 
OPTION ranker = 'bm25'

In this case everything works fine, but I still need to add topics from the current user and I would like to do something like

SELECT id, WEIGHT() as relevance FROM posts 
WHERE MATCH('(@content world|peace|leo) (@content_2 photography)') 
ORDER BY relevance DESC 
OPTION ranker = 'bm25', field_weights=(content=10,content_2=5)

But how to do it without duplicating `content` in `content_2`? After all, this will double the index.

Answer 1

SELECT id, WEIGHT() as relevance FROM posts 
WHERE MATCH('(@content world|peace|leo^10) (@content photography^5)') 
ORDER BY relevance DESC 
OPTION ranker = 'bm25'