I found that the wildcard character (*) can't be use when i use PostgreSQL as the database for mediawiki, but only when i use MySQL database for the mediawiki.
After upgrading from PostgreSQL v8.3.3-1 to v8.3.4-1 the search works a bit better. Now MediaWiki can find articles with the word "skovningssystem" if I search for "skov". Unfortunately it still can't find articles with the word "TM2200" if I search for "TM" or "2200".
I want to thank Greg for his explanation about "word stemming". Now the search results make sense ;)
-----Oprindelig meddelelse----- Fra: Greg Sabino Mullane [mailto:greg@endpoint.com] Sendt: 16. oktober 2008 17:35 Til: MediaWiki announcements and site admin list Cc: rve@techno-matic.dk Emne: Re: [Mediawiki-l] Can't get Wildcard search in MediaWiki to work with PostgreSQL
I for instance can search for "rabbit" and find something, but find nothing by searching for "rabbi*" or "rabbi%".
Searching (in Postgres on MediaWiki) works on word stemming, so that any search term is broken down to its base, and the base words are compared against an indexed. There is no support for searching arbitrary collections of letters, which seems to be what you want. Doing such a thing would be an extremely time-consuming task on all but the tiniest of wikis, as there is no way to index such arbitrary searches. If this is something you really wanted, however, you could probably write an extension and/or global flag to do the searching by producing SQL similar to:
SELECT * FROM page_content WHERE old_text ~ 'rabbi' WHERE ...
-- Greg Sabino Mullane greg@endpoint.com End Point Corporation