Suppose there is a SQL query:

SELECT * FROM articles WHERE MATCH (title, body) AGAINST ( '+Привет +"Как дела" +Отлично +"хорошее настроение" +"Салон Связи"' IN BOOLEAN MODE);

How can I get back + the words for which the article was found?

PS interested in a solution for PHP.

  • The question is not very clear. Give an example of what you need to get. - AntonioK
  • The query above, in the form of a result, I want something like "The article was found by the query 'Hello, how are you, fine' the other words that were used were not found in the article." - Quiss
  • regexp probably. if (preg_match('~AGAINST\h*\(\'\K[^\']+~i', $text, $match)) echo $match[0]; - Deadooshka

0