Compare against Substring of Field

Databases
1

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…

f21190299a795e9cf3439f7f62c223f79e023ab7

Whereas in the database I have the full Filename and Extension…

f21190299a795e9cf3439f7f62c223f79e023ab7.jpg

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

Thanks,

Debbie

2

MIME type?

also, is this actually a php question?

3

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.