SOUNDEX might meet your needs
http://www.mysql.com/doc/en/String_functions.html Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net tel. 0121-242-1473 ----------------------------------------------- -----Original Message----- From: FABIAN VON ROMBERG [mailto:[EMAIL PROTECTED]] Sent: 05 October 2002 22:50 To: [EMAIL PROTECTED] Subject: Need to match similar words Hi, is there any chance in MySql to match similar strings and rate it? Ex: string: apples criterias: apples 100% apple 90% appl 80% applee 50% appple 15% Any help will be much appreciated. Thanks in advance, Fabian _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php