Code: Select all
ALTER TABLE articles ADD FULLTEXT(title, content);The table is a MyISAM table on MySQL Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486).
So then I stuck "test" into some of the titles, and again in some of the contents.
I then did:
Code: Select all
SELECT * FROM articles WHERE MATCH (title, content) AGAINST ('test');Code: Select all
SELECT * FROM articles WHERE MATCH (title, content) AGAINST ('test' IN BOOLEAN MODE);