MySQL 4+ has these restrictions, I know, regarding fulltext search queries:
1) Words must be 4+ characters
2) Resultset must be 3+ rows
3) Keyword must be in < 50% of resultset
Problem is, the client wants the following:
1) Words to be 3+ characters
2) Resultset be at least 1 row
3) Keyword can be up to 100% of resultset
The 3-letter rule is most important because government agencies can be TLA (three-letter acronyms).
I am having to change the parameters then in MySQL, however, I don't know what to change, and...
..here's the kicker..
They want the changes to ONLY be in effect temporarily. That means I would probably have to do something like this in PHP to do it:
$msg = exec("mysql -h $host -u $user --password=$password --{variable}={value} 2>&1");
Is this possible/doable?
Thanx
Phil
