Skip to main content

Posts

Showing posts from March, 2013

HOW TO USE FULLTEXT SEARCH IN MYSQL - MATCH ... AGAINST SYNTAX

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

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

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

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



Urgent Openings for PHP trainees, Andriod / IOS developers and PHP developers in Kochi Trivandrum Calicut and Bangalore. Please Send Your updated resumes to recruit.vo@gmail.com   Read more »
Member
Search This Blog