i have a sql statement to execute in mysql for fulltext search like this.
"select url from search where match(description) against ('oracle application server') limit 20"
but the record set is pretty big, so i want to return first 20 rows. but the first 20 rows that are returned don't include this phrase in order "oracle application server".
I want to return first 20 rows that contain this phrase in order "oracle application server" and narrow it down(maybe rows that contain one of these three words). but this sql statement returns first rows that contain any words.
i tried "where description like '%oracle application server%'. it works ok, but it's really slow, even though i created an index on description column.
I am using java to implement this like this.
stmt = conn.createStatement(); stmt.execute(selectQuery); rs = stmt.getResultSet();
i searched the mailing list, but i can't find an answer that i want.
so if anybody knows how to do it, please let me know.. i'd appreciated it...
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
