Avatar of Marius0188
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 :)
MySQL ServerMicrosoft SQL Server

Avatar of undefined
Last Comment
johanntagle

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
johanntagle

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Marius0188

ASKER
Mmmh I see.
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!
:)
johanntagle

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.
johanntagle

Update on this: by default I don't think fulltext searches for numbers.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23