MYSQL Full-Text Search

Welcome to www.ThaiCreate.Com the best free tutorials

[Welcome] [to] [www.ThaiCreate.Com] [the] [best] [free] [tutorials]

CREATE TABLE `customer` (
`CustomerID` varchar(4) NOT NULL,
`Name` varchar(50) NOT NULL,
`Email` varchar(50) NOT NULL,
`CountryCode` varchar(2) NOT NULL,
`Budget` double NOT NULL,
`Used` double NOT NULL,
PRIMARY KEY (`CustomerID`),
FULLTEXT (`Name`,`Email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `customer` ADD FULLTEXT(`Name`,`Email`);

INSERT INTO `customer` VALUES ('C001', 'Win Weerachai', '[email protected]', 'TH', 1000000, 600000);
INSERT INTO `customer` VALUES ('C002', 'John Smith', '[email protected]', 'EN', 2000000, 800000);
INSERT INTO `customer` VALUES ('C003', 'Jame Born', '[email protected]', 'US', 3000000, 600000);
INSERT INTO `customer` VALUES ('C004', 'Chalee Angel', '[email protected]', 'US', 4000000, 100000);

SELECT * FROM `customer` WHERE MATCH (Name,Email) AGAINST ('jo')

SELECT * FROM `customer` WHERE MATCH (Name,Email) AGAINST ('Born')

SELECT * FROM `customer` WHERE MATCH (Name,Email) AGAINST ('Born Weerachai')