Compare against Substring of Field
I need to take a Filename generated by my PHP script and compare it against the name in the "photo_name" field.
The problem, is that my PHP script is just generating...
Whereas in the database I have the full Filename and Extension...
Unfortunately, when I am checking to make sure the new Filename is unique in my PHP Script, I have not determined the MIME type, and so I need a way to do this lopsided comparison, if that makes sense?!