MySQL Forums
Forum List  »  Full-Text Search

Re: Fulltext search with prefix %like%
Posted by: Ray
Date: October 01, 2005 01:11AM

Hi Smitha,

Can you give me an example of a query string that would work the same as fulltext searching, but that would be fast as well? I have a table with 600000 records that needs to be searched and results returned in seconds.

I understand that %like% is rather slow because of the prefix %

I am a MSSQL programmer and new to MySQL.

With thanks
Ray

Options: ReplyQuote


Subject
Views
Written By
Posted
6257
Ray
September 24, 2005 03:59PM
2911
October 01, 2005 12:06AM
Re: Fulltext search with prefix %like%
3296
Ray
October 01, 2005 01:11AM
2542
October 10, 2005 01:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.