I am using MySQL FullText indexing on a new project of mine.
What I don't understand is how inconsistent this functionality is.
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:
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 :)