Could someone please give me an advice?
I have five tables that contain information about users.
Is it possible to create a FULLTEXT INDEX of some fields of these 5 tables in another separate (sixth) table?
As a result I need to be able to output full user profile which contains most of all search matches, as first element, then with a bit less matches and so on, depending on the relevancy.
I have five tables that contain information about users.
Is it possible to create a FULLTEXT INDEX of some fields of these 5 tables in another separate (sixth) table?
As a result I need to be able to output full user profile which contains most of all search matches, as first element, then with a bit less matches and so on, depending on the relevancy.
