[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

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

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

[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