How to get a filename's extension in MySQL?
<p>I'm importing records into a system that has a separate column for a file's extension, e.g. <code>jpg</code>. How can I use MySQL string handling to extract the extension?</p>