Database searches

Hi,

I'm looking into how I can search some text fields in an Oracle DB (8i on Linux Red Hat 6.1) for our website, both input-terms-into-searchbox type searches, and also stealth, under-the-cover searches to show more relevant news articles, etc, depending on what area of the website the user wanders onto. This feature will be heavily used on our site, I think that using simple "select * from news where title like '%$searchterm%' or body like '%$searchterm%'" statements would degrade performance too much. I would also like a little bit of intelligence in the seearch if possible (ideally the results would be as relevant as a good 'regular' search engine).

I think the Internedia cartridge may be able to do what I want - has anyone here used it? Can anyone point me in the direction of a URL that demonstrates what Intermedia can do?

thanks,

• Kev