ADDING AND REMOVING OF FULL-TEXT INDEX – MYSQL FULLTEXT SEARCH – QUICK REFERENCE GUIDE – HOW TO ADD FULLTEXT INDEX – HOW TO REMOVE FULLTEXT INDEX

FULL-TEXT SEARCH IN MYSQL

Full-text search helps to generate a better and relevant search result.

In MySQL Full Text searching is only supported by the MyISAM storage engine.

FULL TEXT Search is applicable to Fields having data type VARCHAR or TEXT

Full-text Searches are not case sensitive

Basically there are 2 stages of FULLTEXT Searching
(1) INDEXING
(2) SEARCHING

Full-text searching is performed using MATCH()AGAINST syntax.

SYNTAX EXAMPLE:
SELECT Product_Title, Product_Details FROM tbl_Products
WHERE MATCH (Product_Title,Product_Details) AGAINST (‘MySQL DataBase’);

CLICK HERE TO KNOW HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE
CLICK HERE TO KNOW HOW TO REMOVE FULLTEXT INDEX FROM A COLUMN IN MYSQL TABLE
CLICK HERE TO KNOW VARIOUS OPTIONS IN FULL-TEXT SEARCH
 MYSQL FULLTEXT SEARCH – QUICK REFERENCE GUIDE – ADDING AND REMOVING OF FULL-TEXT INDEX.

Advertisements

5 thoughts on “ADDING AND REMOVING OF FULL-TEXT INDEX – MYSQL FULLTEXT SEARCH – QUICK REFERENCE GUIDE – HOW TO ADD FULLTEXT INDEX – HOW TO REMOVE FULLTEXT INDEX

  1. todopaulaustercomes

    Heya exceptional blog! Does running a blog similar to this take a
    massive amount work? I’ve very little understanding of computer programming however I had been hoping to start my own blog in the near future. Anyway, should you have any ideas or techniques for new blog owners please share. I understand this is off topic however I just had to ask. Appreciate it!

    Hey : Check here for BEST BLOGGING TECHNIQUES OR Click Here

  2. Hairstyles

    Ahaa, its nice conversation on the topic of this article here at this blog, I
    have read all that, so now me also commenting here.

    hairstylesfitter [.] com

  3. PHP-TECHI

    REMOVAL OF FULL TEXT INDEX

    ALTER TABLE `tbl_table` DROP INDEX `fulltextKEY`;

    OR

    DROP INDEX `fulltextKEY` ON `tbl_table`

    fulltextKEY is the Key name you have assigned ( or mysql assigned) to the Full-text index. To know the keyname, you have to run the sql stmt:

    SHOW CREATE TABLE tbl_table;

    thanks 🙂

  4. PHP-TECHI

    Sample MySQL Statement to add fulltext index to 2 columns of a table
    ALTER TABLE tbl_Products ADD FULLTEXT(Product_Title, Product_Details);

Your Comments Please

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s