Tecquila

There are questions like: HOW TO DE-INDEX WEBPAGES? HOW TO REMOVE SITE FROM SEARCH ENGINE RESULTS? HOW TO PREVENT SITE FROM BEING INDEXED BY SEARCH ENGINES? HOW TO REMOVE WEBSITE FROM SERP? In-order to avoid site from indexing or showing up in search results you can do following: -----------------

HOW TO USE FULLTEXT SEARCH in MYSQL - MATCH ... AGINST SYNTAX First You have to apply FULL-TEXT index to the Columns of your table Once you have a FULLTEXT index, you can search it using MATCH and AGAINST statements Here is the search Query based on a sample table "tbl_Products":

HOW TO REMOVE FULLTEXT INDEX FROM COLUMN IN MYSQL TABLE for this first you check the DDL of your table Here given the example which is based on a sample table "tbl_Company" Run following Query to display the DDL for your table, including the system-assigned name for the index.

HOW TO ADD FULLTEXT INDEX TO A COLUMN IN MYSQL TABLE Here given the example which is based on a test table "tbl_Products" How to Create MySQl table with Full-Text indexed columns? To create a table with Full-Text indexed columns, use query like this: CREATE TABLE tbl_Products ( `Product_Id` int(11) NOT NULL auto_increment, `Product_Title` varchar(150) , `Product_Details` Text, PRIMARY KEY (`Product_Id`), FULLTEXT KEY `Product_Title` (`Product_Title`,`Product_Details`) ) ENGINE=MyISAM

MYSQL FULLTEXT SEARCH - QUICK REFERENCE GUIDE - ADDING AND REMOVING OF FULL-TEXT INDEX FULL-TEXT SEARCH TUTORIAL Full-Text search refers to techniques for searching a single computer-stored document or a collection in a full-text database. Here, the search engine examines all of the words in every stored document as it tries to match search criteria. Two Stages of Full-Text search Basically there are 2 stages (1) INDEXING   (2) SEARCHING