Keyword search on all columns of multiple tables in sql server
- by hiralshah
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
…