Bug #1060 Standard function enhancement to MATCH queries
Submitted: 15 Aug 2003 21:26 Modified: 16 Aug 2003 1:28
Reporter: Brian Cunningham Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S4 (Feature request)
Version:all OS:Any (any)
Assigned to: CPU Architecture:Any

[15 Aug 2003 21:26] Brian Cunningham
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.
[16 Aug 2003 1:28] Sergei Golubchik
Yes, most of these features are in todo and will be added to MySQL.