Keyword search on all columns of multiple tables in SQL Server

Question

Dear all,

We are maintaining the profile information’s (like profile first name, last name, address, city, state, age, religion, occupation, education, etc….) from tbl_profie table in SQL Server.

The users can search profiles using any keywords like

Example 1: MBBS, Delhi, India
Example 2: MBA, Delhi, cricket
Example 3 : London, Hindu

Tbl_profile table defending some parent table like Tbl_city, Tbl_state, Tbl_country, Tbl_occupation, Tbl_education tables, etc.

So how to fetch user search results from Tbl_profile and profiles related tables using user’s keyword with easiest way.

Answer 1

Build the reverse index table. And use SQL job to update the table every hour.