Re: Search thoughts
| From: | Eric Butera | Date: | Sat, 19 Jul 2008 17:56:11 +0000 |
| Subject: | Re: Search thoughts | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-277088@lists.php.net to get a copy of this message | ||
On Sat, Jul 19, 2008 at 5:47 AM, Richard Heyes <richardh@phpguru.org> wrote:
> Hey,
>
> I was hoping to get some ideas on improving a sites search. Currently I have
> two - not a lot but I've been thinking about this for a few minutes.
>
> Currently the site in question uses a very basic LIKE in MySQL, eg %blah%,
> but naturally this finds terms such as hjkblahbjkk - which is not desired.
> Or such matches should be ranked lower than something that matches the exact
> word blah. My thoughts are using a points system, eg assigning 5 points for
> an exact word match, 1 for a partial match. And then ordering the search
> results by the total points assigned.
>
> Either that or using external search code and not worrying so much.
>
> Cheers.
>
> --
> Richard Heyes
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Ever play with fulltext search?