Note that the full-text modes only support prefix searching. For postfix you could either reverse the field your looking for (redundant data in your table), or

Note that the full-text modes only support prefix searching. For postfix you could either reverse the field your looking for (redundant data in your table), or use something like sphinx; which nowadays has great integration with MySQL.