Tag: MYSQL, MYSQL / Home

MYSQL

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
Home » MYSQL

  • Search Engine type search

    3 answers - 1139 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    K, I appear to be getting somewhere with the FULL TEXT search. Does anyone have any good resources about producing search engine type results ? for example if some enters a search phrase like londn how would I suggest the word london ?
    From: jschwartz (AT) the-infoshop (DOT) comTo: dmagick (AT) gmail (DOT) com; neildtompkins (AT) hotmail (DOT) comCC: mysql (AT) lists (DOT) mysql.comSubject: RE: Search Engine type searchDate: Wed, 23 Aug 2006 12:18:59 -0400Actually, by default a full text search ignores words that are threecharacters or less, not less than three characters.I found this out by searching on "red".Regards,Jerry SchwartzGlobal Information Incorporated195 Farmington Ave.Farmington, CT 06032860.674.8796 / FAX: 860.674.8341other thing - in case the restrictions page didn't mention this,fulltext by default ignores words which are less than 3 characters long.You can change this, it'll be in the docs somewhere - "ft_min_word_len".-- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe: @hotmail.com
    Be one of the first to try Windows Live Mail.

  • No.1 | | 816 bytes | |

    K, I appear to be getting somewhere with the FULL TEXT search. Does
    anyone have any good resources about producing search engine type results
    ? for example if some enters a search phrase like londn how would I
    suggest the word london ?

    Hi Neil,

    That's a completely different thing, but very common to see both together.

    I'd say a good way of doing this is to have a from/to table and when the
    user search for "from" and "to" have more results (replace and search to
    check) you show him a "did you mean" box with the new word in bold.

    It's really hard to extract that information from searches anyway so the
    best you can do, as far as I know, is to monitor the common mistakes by
    looking into logs and adding terms to that table manually.

    cheers,

  • No.2 | | 707 bytes | |

    Neil Tompkins wrote:
    K, I appear to be getting somewhere with the FULL TEXT search. Does anyone have any good resources about producing search engine type results ? for example if some enters a search phrase like londn how would I suggest the word london ?

    I was listening to a podcast a while ago that explained this (can't find
    the reference sorry) and basically what they do is if the search term
    contains no results or only a few results, log what the person types in
    next to search for.

    The most common "next search" becomes the "did you mean".

    Whether that's true or not I don't know but it's a pretty simple idea
    and would work reasonably well.

  • No.3 | | 583 bytes | |

    Chris wrote:
    The most common "next search" becomes the "did you mean".

    Yes, that might work well, but I wouldn't use it out of the box. I would
    send a report to a human first to use that information instead of doing
    it automatically.

    Imagine someone searching for "cous" (instead of "cows") and than,
    search for "sex". As "sex" is by far the most searched it's probable
    that it becomes the next search (specially after dubious words such as cow).

    Now imagine your son searching for "cows" for his school homework

    :)

    cheers,

Re: Search Engine type search


max 4000 letters.
Your nickname that display:
In order to stop the spam: 5 + 5 =
QUESTION ON "MYSQL"

EMSDN.COM