How to remove the spaces besides hiphen in mysql?
===

I am getting the image names from mysql database. I have my images containing two to three words with png extension. Also the names contains hiphen symbol. First I want to remove the 
space to the left and right of the hiphen symbol. Secondly, I want to replace the space between two words with underscore symbol. How can I write the query for this?


Thanks in advance