Professional Web Applications Themes

name searching - MySQL

Hello, I want to search for a name in a mysql database. Name-searching can be tricky. Let's say I want to find "Boer". This should match "de Boer", "Jager-Boer" and "Boer-Kok" , but not "Boersma". I tried pattern matching, but this was far too slow. To me this looks like a standard problem, and there is probably a standard solution. Can someone help? Thank you...

  1. #1

    Default name searching

    Hello,

    I want to search for a name in a mysql database. Name-searching can be
    tricky.

    Let's say I want to find "Boer". This should match "de Boer",
    "Jager-Boer" and "Boer-Kok" , but not "Boersma". I tried pattern matching,
    but this was far too slow.

    To me this looks like a standard problem, and there is probably a standard
    solution. Can someone help?

    Thank you
    JD Guest

  2. #2

    Default Re: name searching

    JD wrote:
    > Hello,
    >
    > I want to search for a name in a mysql database. Name-searching can be
    > tricky.
    >
    > Let's say I want to find "Boer". This should match "de Boer",
    > "Jager-Boer" and "Boer-Kok" , but not "Boersma". I tried pattern
    > matching, but this was far too slow.
    >
    > To me this looks like a standard problem, and there is probably a
    > standard solution. Can someone help?
    FULLTEXT search has a lot to offer, but if pattern matching (%Boer%) is to
    slow, maybe that's not the solution..
    [url]http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html[/url]

    Grtz,
    --
    Rik Wasmus


    Rik Guest

  3. #3

    Default Re: name searching

    On 2006-05-18, Rik <luiheidsgoeroehotmail.com> wrote:
    [...]
    >
    > FULLTEXT search has a lot to offer, but if pattern matching (%Boer%) is to
    > slow, maybe that's not the solution..
    > [url]http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html[/url]
    Thank you for your pointer. Simple patter matching (%Boer%) is fast
    enough, but does not meet my criteria (far too many results). More
    precise matching is really slow.

    Greetings

    JD Guest

  4. #4

    Default Re: name searching

    JD wrote:
    > On 2006-05-18, Rik <luiheidsgoeroehotmail.com> wrote:
    > [...]
    >>
    >> FULLTEXT search has a lot to offer, but if pattern matching (%Boer%)
    >> is to slow, maybe that's not the solution..
    >> [url]http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html[/url]
    >
    > Thank you for your pointer. Simple patter matching (%Boer%) is fast
    > enough, but does not meet my criteria (far too many results). More
    > precise matching is really slow.
    Could you specify what those criteria are exactly? That would a big help in
    pointing you to a solution that is usefull.

    Grtz,
    --
    Rik Wasmus


    Rik Guest

  5. #5

    Default Re: name searching

    On 2006-05-19, Rik <luiheidsgoeroehotmail.com> wrote:
    > JD wrote:
    >> On 2006-05-18, Rik <luiheidsgoeroehotmail.com> wrote:
    >> [...]
    >>>
    >>> FULLTEXT search has a lot to offer, but if pattern matching (%Boer%)
    >>> is to slow, maybe that's not the solution..
    >>> [url]http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html[/url]
    >>
    >> Thank you for your pointer. Simple patter matching (%Boer%) is fast
    >> enough, but does not meet my criteria (far too many results). More
    >> precise matching is really slow.
    >
    > Could you specify what those criteria are exactly? That would a big help in
    > pointing you to a solution that is usefull.
    Sorry, my mistake, I have no knowledge of FULLTEXT. I need to
    study this carefully to see how this can work for me.
    JD Guest

Similar Threads

  1. WE KNOW EXACTLY WHAT YOU'RE SEARCHING FOR!
    By Broadway_Rose in forum Macromedia Shockwave
    Replies: 1
    Last Post: August 2nd, 03:41 AM
  2. Searching Dates
    By Supercyberal in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 26th, 06:25 AM
  3. Searching in a PDF doent
    By Andrew_Wiegert@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 6
    Last Post: May 24th, 11:59 AM
  4. searching files
    By Seph webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 11
    Last Post: January 22nd, 06:39 AM
  5. [PHP] searching date
    By Jay Blanchard in forum PHP Development
    Replies: 0
    Last Post: August 14th, 08:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139