MySQL Forums
Forum List  »  Full-Text Search

Full Text Searh from middle of word
Posted by: janaki gokaraju
Date: April 28, 2009 08:02AM

Hi,

I am using Full Text Search. I am able to search multiple words, single full words, and word from starting point to middle point (By adding '*' at the end of the string). But not able to search the word from middle of word to the last point and middle characters in a word.
Let me explain with an example.

I am searching for a string "Technology"
I searched for "Techno" then I am able to get the row which has "Technology"
After that I searched for "hnology" (from middle to end) then I am able not able to get the row which has "Technology".
After that I searched for "chnolo" (middle content) then I am able not able to get the row which has "Technology".

Is it possible to search like this? If so, Please help me regarding this.

Thank you in advance


Thanks & Regards,
Janaki.

Options: ReplyQuote


Subject
Views
Written By
Posted
Full Text Searh from middle of word
5636
April 28, 2009 08:02AM


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.