I have a CHAR column in one of my tables which has the following values: "number space number space" like "1 7 29".
I want to add a FULLTEXT search to this column, but this just doesn't work:
SELECT *
FROM factories
WHERE match (compMainAct) against ($HTTP_GET_VARS['catID'])
An index has been created on this column.