Description:
In response to Monte Ohrt: I would like to
be able to choose how a query string is treated
in a FULLTEXT search.
That is, I would like to see an optional
function related to search that would take the
field and the search method as a parameter.
So then I could override the default method
with a syntax something like SELECT MATCH (mytext)
AGAINST INDEXTYPE ('run', stemmed) AS x FROM info. Or,
perhaps, add this functionality to MATCH itself.
Similarly I'd like to be able to specify the
smallest word to index in my CREATE statement.
Personally, I use partial word searches only when I
don't know how to spell something. A silly example: Is
it "socket" or "sockit"? My search for sock
should be able to search using "sock" and return
more than just "sock" and "socks".
As an aside: Then, in an app, I might make it so
the user can choose to override the default search
method using radio button selections (for example).
How to repeat:
This is a feature request. The way to repeat the opposite of what I want is to do a FULLTEXT search with any parameters using any released version of MYSQL.
Suggested fix:
See description.
Description: In response to Monte Ohrt: I would like to be able to choose how a query string is treated in a FULLTEXT search. That is, I would like to see an optional function related to search that would take the field and the search method as a parameter. So then I could override the default method with a syntax something like SELECT MATCH (mytext) AGAINST INDEXTYPE ('run', stemmed) AS x FROM info. Or, perhaps, add this functionality to MATCH itself. Similarly I'd like to be able to specify the smallest word to index in my CREATE statement. Personally, I use partial word searches only when I don't know how to spell something. A silly example: Is it "socket" or "sockit"? My search for sock should be able to search using "sock" and return more than just "sock" and "socks". As an aside: Then, in an app, I might make it so the user can choose to override the default search method using radio button selections (for example). How to repeat: This is a feature request. The way to repeat the opposite of what I want is to do a FULLTEXT search with any parameters using any released version of MYSQL. Suggested fix: See description.