[Mediawiki-l] Full text searching

Chris McIntosh cmcintosh at gmail.com
Wed May 24 00:42:46 UTC 2006


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



More information about the MediaWiki-l mailing list