[Wikipedia-l] Re: Searching

Axel Boldt axel at uni-paderborn.de
Sat Aug 17 01:19:00 UTC 2002


> I initially resisted because it would require copying all of MySQL's
> stoplist into the PHP code,

That gets to complicated. Why not simply use the mysql search engine
the way it is intended to, feeding it the whole search string in one
piece, rather than cutting it into words and start a separate search
for every word? With a newer version of mysql, we can even continue to
use boolean search ("IN BOOLEAN MODE"). Also, you generate fewer SQL
queries, and mysql create meaningful result scores. Furthermore, you
gain the ability to search for phrases, which we don't have currently.

Axel



More information about the Wikipedia-l mailing list