oracle text equivalent in MySql?

[tomboy78]

I want to improve a site by adding a search function. I have heard about oracle text, which is supposed to be nice and all that.

However, the ISP supporting the site does not support oracle so I will have to use MySql.

What is the best way to do a 'search the site' function in MySql?

future thanks
tom

[Sxooter]

Search the mysql docs for "full text indexing" they have a nice little built in engine for doing this that's quite zippy fast.