In our wiki a user is complaining about not being able to search for
the word "-crtcA_cfg" in a wiki page.
If they search for ctrcA_cfg the wiki finds it, but if they search for
-crtcA_cfg it does not.
Anyone know if there is a way to solve this?
I am not very familiar with full text searching but it appears the
following works.
Broken version, what mediawiki does.
mysql> select si_title from searchindex where MATCH(si_text) AGAINST
('+\-crtcA_cfg' IN BOOLEAN MODE);
Empty set (0.00 sec)
What appears to work.
mysql> select si_title from searchindex where MATCH(si_text) AGAINST
('+*-crtcA_cfg' IN BOOLEAN MODE);
+---------------------+
| si_title |
+---------------------+
| know crtfiles |
| know displayfaq |
| know mdiagarguments |
| know scalingclocks |
+---------------------+
4 rows in set (0.00 sec)
Is this the proper thing to do?
Thanks,
Chris McIntosh