Re: Full Text search

[Rick James]

You need these:
FULLTEXT(title, body) -- in news
FULLTEXT(title, body) -- in body
FULLTEXT(question, answer) -- in faq

SELECT ... FROM news n JOIN ...
WHERE MATCH(n.title, n.body) AGAINST(+nika +chitanava IN BOOLEAN MODE)
UNION DISTINCT
SELECT ... FROM body b JOIN ...
WHERE MATCH(b.title, b.body) AGAINST(+nika +chitanava IN BOOLEAN MODE)
UNION DISTINCT
SELECT ... FROM faq f JOIN ...
WHERE MATCH(f.question, f.answer) AGAINST(+nika +chitanava IN BOOLEAN MODE);

The SELECT ... should fetch the same stuff.
The JOIN... should be JOINing the three tables.