jaykup

I've already got a "search engine" for mySQL using "like" and "%", which works great. But sometimes it does not return a result. I would like to have a small case block for some major ones (mis-spellings) and re-do the search with a new value. The above code is confusing, I'll try to make it better. user enters a search - "bananna" which will go to "$search" switch ($search) { case "bana*": echo "You were trying to seach for 'banana', but typed in 'bananna' so I'll run my query with 'banana'"; $query = mysql_query("SELECT banana FROM fruits"); break; } I've tried that but PHP sees a literal "*"

$search = "somethi"; switch ($search) { case "somethi*" in "something": echo "you found something, which is close to your entered search of somethi"; break; } How can I do something like that?