none
HOW TO WRITE SEARCH ENGINE QUERY FOR A DATABASE CONTAIN 3 TABLES

    Frage

  • HOW TO WRITE SEARCH  ENGINE  QUERY  FOR A DATABASE  CONTAIN 3 TABLES

    IMAGINE  DATABASE NAME  STUDENTDETAIL

    WHICH 

    IS HAVING  3 TABLE

          1. FACULTY

         2.STUDENT

         3.OFFICE STAFF

    THE  THREE  TABLE ARE  INNER JOINED BY PRIMARY KEY AND FOREGIN KEYS

    IF ANY ONE FIND SOLUTION PLEASE SHARE


    FOR EXAMPLE  IF I AM   SEARCH ING  

    A  WORD  'BALA WHEERE'

    IAM  JUST TRYING THIS BUT  I DIDNT FIND SOLUTION

    Montag, 12. März 2012 07:01

Antworten

  • Your descriptions are not complete. What do you mean by a 'Search Engine Query'? If you want to find rows having a particular name then you can use a simple LIKE predicate like this:

    SELECT * FROM Faculty WHERE FacultyName LIKE '%BALA WHEERE%'

    However this will not be SARGable (index freindly). If your application has to do a wide variety of character searches then the best option is to go for Full Text Search feature in SQL Server. Have a look at  the below link for a start up.

    Full-Text Search

    - Krishnakumar S

    Montag, 12. März 2012 08:34

Alle Antworten