wildcard. It tries out different variations of the wildcard search.
Anyway, my question is:
Does MySQL include anything that could make this easier for me? I recall hearing mention of a "search" function in MySQL that finds the cells in a column with the most matching characters or something. In the cases where my wild-card search fails it would be a great tool to have.
Anything else that would help with finding matches to mistyped addresses would be great.

A:

One option might be to try to use SOUNDEX to get you close to what you want.  SOUNDEX will make matches off of pronunciation so it might get you closer if people are mistyping based off of the phonetic spelling of a street name.
You might also try the Levenshtein distance algorithm.  This is probably more closely tied to what you are looking for.  Basically it looks at how close one word is to another.  It can be used for spell checking, etc. and it might be useful when looking for bad data in address fields.  Here is a link to it:
http://www.merriampark.com/ld.htm
If you want the function to use the Levenshtein distance algorithm in MySQL, you can look at an example here:
http://www.artfulsoftware.com/infotree/queries.php#552



Q:

Default filename of image dragged from the browser window

In Safari, when I drag an image from the browser window to the desktop the image take its filename from the last part of the URL. For example:
http://www.mysite.com/images/05

the image name is
05.jpeg

Is this a behaviour consistent across all (recent IE8+) browsers?
Can I decide an arbitrary filename the image will get when dragged out of the browser?
I tried (in Safari) to set the name and alt tag of the image but this doesn't have any effect.
Maybe can I decide the filename setting it in the header of the server response when the image is served?

A:

One method is to specify the desired filename in the header of the response when the file is served.
I'm on php so...
header('Content-disposition: inline; filename=the-image.jpg');

When the image is dragged from the