title: Spliting MySql value with default function in mysql?
body: <p><strong>I Have a sitatation like the following:</strong></p>
  
  <p>In MySql Table Entries:</p>
  
  <pre><code>img_id name 
  
  1      aa.jpg             
  2      aab.mpeg             
  3      aabc.jpg             
  4      aabd.jpg             
  5      aabn.jpg             
  6      aabf.jpg             
  7      aadf.jpg             
  8      aacf.jpg    
  </code></pre>
  
  <p>I want the count after splitting thew above values........</p>
  
  <p>like </p>
  
  <pre><code>".jpg"=&gt;7
  ".mpeg"=&gt;1
  </code></pre>