Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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,