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 ....

Easy way to use like operator for you mysql query.

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!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.