Is there any way in MySQL to force underscore to become a word splitter character (like space or dash) without having to use a fulltext parser plugin?
If not, does such a plugin already exist or do I have to learn to make my own?
I have never heard of such a plugin. Sure, you could make your own plugin.
However, I have a rather wild suggestion if you can afford the diskspace.
Let's take an example table:
Let's say a table like this is populated already.
Suppose you want to index any words such as
You may want to create a separate column with the underscores replaced with blanks. You will have to perform the following conversion
Once done, the table should look like this
This will index the data both ways. Consequently, this blows up the table and index files in size.
You will have to do searching with the following clause
Please perform this on a test server, look at the increased size of the new table and index. You can decide whether this table layout provides the data you want with tokens separated.
Give it a Try !!!