fulltext search in version 4.0 is very good. Take a look at the mysql docs and you can take a look at how to use the built in fulltext search provided.

__________________
NEWEDGE Services, Inc. - Developers of ClientExec