MySQL Forums
Forum List  »  Full-Text Search

using mysql to search strings containing a given substring
Posted by: divedeep
Date: December 27, 2005 07:23AM

I am creating a server indexing files in my local area network, in
order to provide a searching feature.
So i want to make it possible to search such rows where the 'name'
(VARCHAR) column contains a substring submitted by user.
Can i use a full-text index to make it faster? from my first sight i
noticed that this index can be used to search for words in a string. So
the example below would not go any way:
searching 'cool' in 'uncoolness'
Am i right? Are there any other solutions? Maby some other databases
provide this use case?
thx

Options: ReplyQuote


Subject
Views
Written By
Posted
using mysql to search strings containing a given substring
4110
December 27, 2005 07:23AM


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.