Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Full Text Search

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 154
    Comment on it

    Full Text Search is a way to provide faster search on your website. Suppose you creating a website for a newspaper where lots of article written on various subject and now you want to fetch all news related to word Modi. Full text search is ideal for this situation.

          ALTER TABLE news ADD FULLTEXT(headline, story);
          SELECT headline, story FROM news WHERE MATCH (headline,story) AGAINST ('Modi')
    

    Note : FULLTEXT search only to be work varchar, char and text field with MyISAM engine type

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: