Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using match() for fulltext search

Status
Not open for further replies.

windskystar73

Programmer
Jul 8, 2004
5
US
I am building a search engine. but it is kind of complicated. i have a table that three columns, id, url, description. this is my sql.

select id, url from search where match(description) against ('oracle application server') limit 20

when i try this sql, it is really fast, but it doesn't return record set that contains these three words in order, 'oracle application server'. so i tried
match(description) against ('"oracle application server"' in boolean mode) limit 20, but it takes kind of long. and for description like '%oracle application server%', it takes forever.

I want to return record set that contains three words in order and then any words.

i am using Java to implement this. so i am just wondering if there is any better to solve this issue.

if anybody has a better idea, please let me know...

thanks...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top