Re: [PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Pete Holsberg 
On Mon, 6 Sep 2004, Zareef Ahmed wrote:

> HI ,
> 
> Following php  functions may be usefull
> 
> http://www.php.net/soundex
> http://www.php.net/similar_text
> 
> 
> Just try to make good algoritham ;)
> 
> Zareef Ahmed

Thanks!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Pete Holsberg 
On Mon, 6 Sep 2004, David Robley wrote:

> On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote:
> 
> > Is there a way to program MySQL so that it can find the
> > name "Smyth" if the user looks for "Smith"? And similar
> > mispellings that are similar in sound.
> 
> The SOUNDEX string function in mysql may be what you want.
> 
> http://dev.mysql.com/doc/mysql/en/String_functions.html
> 
> Something like
> 
> SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue')
> 
> Cheers
> -- 
> David Robley

Thanks!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Name searches for the spelling impaired

2004-09-06 Thread Zareef Ahmed 
HI ,

Following php  functions may be usefull

http://www.php.net/soundex
http://www.php.net/similar_text


Just try to make good algoritham ;)

Zareef Ahmed




"Pete Holsberg" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Is there a way to program MySQL so that it can find the
> name "Smyth" if the user looks for "Smith"? And similar
> mispellings that are similar in sound.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Name searches for the spelling impaired

2004-09-05 Thread David Robley 
On Mon, 6 Sep 2004 11:09, Pete Holsberg wrote:

> Is there a way to program MySQL so that it can find the
> name "Smyth" if the user looks for "Smith"? And similar
> mispellings that are similar in sound.

The SOUNDEX string function in mysql may be what you want.

http://dev.mysql.com/doc/mysql/en/String_functions.html

Something like

SELECT fields FROM table WHERE SOUNDEX(name) = SOUNDEX('searchvalue')

Cheers
-- 
David Robley

Lead me not into temptation, I can find it myself.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php