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

  • Full Text Search

    @vivek.rastogi
    Recommendations Offline Message

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 242
    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

    Full Text Search Search on article Search on textarea
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           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: