I was trying to figure out how to do a simple search and replace of entries in the database which holds all the text for my site. Since I've rearranged a lot of design components, I needed to change the old links to match the new style for the site.
So you'd think that a full-featured database program should have a query option to find and replace substrings within table entries. And it does, almost. If I want to replace a specific string with another specific string, I can do that. But if I want to replace something which has variable numbers (like the tags that drive the images on my site), wildcards (like % and _ for SQL) don't work AT ALL. So if I want to replace "yadda yadda width='???px' height='???px' " with " " I can't.
So the workaround, for now, is using an .htaccess file to dynamically redirect old links to their new locations. Because .htaccess supports replacing stuff with wildcards. And regular expressions. Because it doesn't suck.
So hopefully you can still access the large-sized photos by clicking on the thumbnails, just as before. If there's a problem, please let me know, because I'll need to fix that if it's still a problem.








