Is Oracle better then MySQL for string searches?

I have created a 1.2M record database on MySQL, which has 3-4 text fields I need to do searches on - I need to match not only whole words, but *parts* of words, this is very important:

select * from emails where subject LIKE "%keyword%" and from LIKE "%keyword%" and to LIKE "%keyword%"

(ps the email table is just an example - its not what Im using it for)

Anyways, I need to these queries to perform fast enough for a web page, but they take about 90 seconds. Unfortunately, MySQL cannot use any type of index to help with searching for terms which have wildcards on both sides of the term.

(closest it comes is the match...against, which allows wildcard on the
right-hand side only)

Anyways, I was wondering if Oracle Linux would be the solution to my problem - can it index this type of query? Could I expect <5s quereies on a 1GB 1.7Ghz machine? Received on Sun Jan 19 2003 - 11:36:48 CST