How to implement Full Text Search with multiple search indexes
I have implemented an Employees List page where a user can search an employee by either name, email, phone, department or role. What I'm trying to achieve in: "select employees where name like value or email like value or phone...etc
Can I implement this functionality with search indexes? If I define multiple indexes (one for name, another for email etc), how could I write the query?
Can I implement this functionality with search indexes? If I define multiple indexes (one for name, another for email etc), how could I write the query?
