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?!



MIME type?

also, is this actually a php question?

If generated Filenames are unique (I’m pretty sure they are), you don’t need an extension, you only need to remove the last 4 chars for the value from the field in the database table to make an exact match.