troubleshooting Question


Avatar of Marius0188
Marius0188 asked on
Microsoft SQL ServerMySQL Server
4 Comments1 Solution595 ViewsLast Modified:
Good day,

I am using MySQL FullText indexing on a new project of mine.
What I don't understand is how inconsistent this functionality is.

For example:
I have the following two rows in a table of 1 column >

When searching for "Value1" (exact unique match) then it returns this row.
But when searching for "Value2" (exact unique match) then it WONT return anything.

In my real database I have the following unique values representing Value1 & Value2 in my example:
1) "YFY678GP"
2) "XT 660 R"

The only difference being value 2 contains spaces.
Could this be so big issue?

Please explain the  logic of FullText indexing in conjunction with MATCH AGAINST?

Thanks to ALL :)
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros