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

Reply via email to