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 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..
http://dev.mysql.com/doc/refman/5.0/...xt-search.html

Grtz,
--
Rik Wasmus

On 2006-05-18, Rik <luiheidsgoeroe@hotmail.com> wrote:
[...]
>
> FULLTEXT search has a lot to offer, but if pattern matching (%Boer%) is to
> slow, maybe that's not the solution..
> http://dev.mysql.com/doc/refman/5.0/...xt-search.html

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 wrote:
> On 2006-05-18, Rik <luiheidsgoeroe@hotmail.com> wrote:
> [...]
>>
>> FULLTEXT search has a lot to offer, but if pattern matching (%Boer%)
>> is to slow, maybe that's not the solution..
>> http://dev.mysql.com/doc/refman/5.0/...xt-search.html
>
> 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

On 2006-05-19, Rik <luiheidsgoeroe@hotmail.com> wrote:
> JD wrote:
>> On 2006-05-18, Rik <luiheidsgoeroe@hotmail.com> wrote:
>> [...]
>>>
>>> FULLTEXT search has a lot to offer, but if pattern matching (%Boer%)
>>> is to slow, maybe that's not the solution..
>>> http://dev.mysql.com/doc/refman/5.0/...xt-search.html
>>
>> 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.