The articles that you pasted is from the manual page on the mysql web site. I replaced it with "codes". mysql> SELECT MATCH(description,body) AGAINST ('Chris') FROM codes; +-------------------------------------------+ | MATCH(description,body) AGAINST ('Chris') | +-------------------------------------------+ | 0 | +-------------------------------------------+ 1 row in set (0.00 sec)