my most common usage of mysql has been web apps, where select queries are the better option.

Full text search is really only usefull for completely internal operations, as the security risks with that specific a query running across the internet are way to high.

I use a combined method in a site search where the user is looking for a specific phrase in a particular area.