
Understanding FULLTEXT Searches
In MySQL, there is a provision to search based on natural mode. Let us consider the following example to understand this in detail. Creation of the table: CREATE TABLE ‘PROP_TBL’ ( ‘PROPERTY’ VARCHAR(100), ‘DOMAIN’ VARCHAR(20), ‘VALUE’ VARCHAR(2000), ‘PATH’ VARCHAR(100), PRIMARY KEY (‘PROPERTY’, ‘DOMAIN’, ‘PATH’), FULLTEXT (PROPERTY,DOMAIN))ENGINE=InnoDB; And use the following