Marius0188
asked on
MySQL FullText & MATCH() AGAINST()
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 >
Column1
--------------
Value1
Value2
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 :)
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 >
Column1
--------------
Value1
Value2
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 :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. Can you give me your actual statement calling the fulltext function?
2. Unfortunately you can't on a shared server. And even if you didn't need to change the settings I don't recommend running an application that regularly uses fulltext on it - it will be slow and/or your host will tell you your app is consuming too much resources.
2. Unfortunately you can't on a shared server. And even if you didn't need to change the settings I don't recommend running an application that regularly uses fulltext on it - it will be slow and/or your host will tell you your app is consuming too much resources.
Update on this: by default I don't think fulltext searches for numbers.
ASKER
Less than 3 characters you say.
1. But "XT 660 R" wont it at least match the "660" phrase?
2. I have shared hosting account - do you know where I can set these mysql server settings?
Thanks a lot!
:)