spelling mistakes ?

[sarithak]

Hi frnds....

i have a problem with input string spelling...

Ex:

$input_string= "amiricaa";
$db_string="America";

when i am searching for amiricaa , than i need to get related words...like America...

how can i do with mysql query ....

[pritaeas]

Maybe this can help:

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex

[jagadishwor]

Easy way to use like operator for you mysql query.

[nav33n]

I would rather do something like this.

select * from table where column REGEXP "am.*.a"

The regular expression will search the column for any value which starts with am and ends with a. I can't think of any other alternative solution!