I have a field in a mysql database that contains a file name which looks like this:
ThisIsMyFile.gif
...and I need to add a new field which contains the English title of this file, like this:
This Is My File
I'm thinking I can write a PHP script to reformat the string and update the record...but am not what the most efficient solution would be. Any thoughts?
I'm basically looking for the PHP script (unless you can recommend a better solution).