Now back in the day when I used "like" for very very simple searches this was not a problem, but in my limited understanding, fulltext is not designed to work that way. I've read up on the "*" operator but it doesn't seem to work for me on the above example. Is this limited to MySQL 5?Can we not just search the whole directory based on the characters entered as above rather than whole words? eg "Rowenta" returns results but not "rowe".
How can I incorporate something like a "like = '$word%'" search without wrecking my Fulltext searching capabilities? I don't want to have to undo my previous hard work!!!