Home > MySQL > Fulltext Search
ALTER TABLE articles ENGINE = myisam;
ALTER TABLE articles ADD FULLTEXT(title, content);
SELECT * FROM articles WHERE MATCH(title, content) AGAINST ('Keyword ');

Reference: http://devzone.zend.com/26/using-mysql-full-text-searching/



Flag Counter