I am having trouble with searching in my MySQL database. I do have FULLTEXT assigned to my table here is my code:

SELECT * FROM btt.btt WHERE MATCH(Solution) AGAINST ('the' IN BOOLEAN MODE)

this returns 0 results when in reality many results should have came back.

Any ideas what I am doing wrong? I have read all the articles on the MySQL pages and it seems I am doing things correctly but obviously I am missing something.