[mythtv] Re: [mythtv-commits] mythtv commits

[Kevin Kuphal]

Bruce Markey wrote:

> "Vie" doesn't match? How big is their stopword list? In addition
> to each word being some form of exact match and no wildcards, each
> word is "or"d. This may not be what we need. For the purpose of
> setting automatic record rules, I kind of like wildcard or regex
> matches. I think the full text searchs would be less flexible, and
> less accurate for limiting the result to exactly what to want to
> record. I think the full text is better suited to scoring results
> for a search box on a website or that kind of thing.

According to the MySQL documentation that I read previously, any word 
under 4 letters is not indexed unless you set a variable in the 
configuration to allow it so it could be done by a user wanting more 
"short word" searching.  I think the idea of prefixing or perhaps even 
having a combo box on the search definition allowing "Use full text 
searching" or "Use exact match searching" could allow the user to choose 
which method to use when checking keywords.  Clear instructions on the 
screen stating that prefixing with + or - will result in boolean 
searching being used I think would suffice to document the feature.  
Then also if MySQL 4 was not detected, the combo would only provide the 
choice of "exact matching" and thereby using LIKE

Kevin