wood burning stoves 2.0*
The moose likes JDBC and the fly likes Strange problem with MySQL full text query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Strange problem with MySQL full text query" Watch "Strange problem with MySQL full text query" New topic
Author

Strange problem with MySQL full text query

Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

This probably has something to do with my understanding of full text search or perhaps a known issue. My Java code creates search term for full text search on MySQL like this -



This works fine if the value in the DB column contains more text than the word itself. However, if the value is exact - no result are returned. I expected it to return results when value is an exact match. Let me give an example -
Assume that DB has column name with value "Manish", now if I search with this -
+Manis*

It does return the result correctly, but if I try this -
+Manish*
It doesn't return any result, though exact match exists in DB column - Name. How can I obtain the desired behaviour in both these cases? Removing + sign works, but it returns far too many results when there are two or more words.

Any help, pointers would be highly appreciated!

Satya Maheshwari
Ranch Hand

Joined: Jan 01, 2007
Posts: 368
Did you check if the word is present in the stopword list.


Thanks and Regards
Manish Hatwalne
Ranch Hand

Joined: Sep 22, 2001
Posts: 2578

Satya Maheshwari wrote:Did you check if the word is present in the stopword list.


NO, the word is not in the stop word list.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Strange problem with MySQL full text query
 
Similar Threads
Search functionality ?!
Ordering Search Results
Strange behaviour when accessing Oracle 8i table from servlet
NX URLyBird 1.3.2: Discrepency in find interface with specs.
mysql database restore