#18904 [WFx->]: search does not allow *all* words

ID: 18904 Updated by: goba@php.net Reported By: ne@clickcom.com Status: Won't fix Bug Type: Website problem Operating System: any PHP Version: 4.2.2 New Comment: AFAIK only bugs.php.net uses the MySQL FTS feature. Other siets are using htdig (htdig.org), which has some limitations, and sometimes small bugs... Previous Comments: ------------------------------------------------------------------------ [2002-08-15 02:30:06] georg@php.net The php.net site uses the mysql fulltext search. This means, that you can't search for words with length < 4 and also words which match 50% of the rows have a minor weight. The LIKE "%word%" statement doesn't work, cause you can't use an index. (Fulltablescan with such amount of data would paralyze php.net). ------------------------------------------------------------------------ [2002-08-14 10:32:03] ne@clickcom.com Today i was searching for a problem where even though my time_limit was set to 30 seconds, I have users getting an error of "Maximum execution time of 5 seconds exceeded" (even though it's set to 30). When I try to search for that phrase, it ignores the "of" and "5" in the search. Ignoring the "5" in this case causes me to get 100's of results instead of more relavent results. I tried putting the search criteria in quotes however the results page then just called me a Bad Hacker and still didn't work. Can anything be done to allow for it to require ALL the keywords to be used or to allow explicit phrase matching? I imagine you're just doing a full-text search but would it be possible to add a LIKE search as an option as well for cases like this? John ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18904&edit=1