is there a mysql command that will change a certain number of characters to something else?

the problem is someone scripted a lyrics script, except it takes each quote and makes it multiple quotes. i don't even know ow to fix it, but i want to at least update the database so it doesn't do '' instead of '

how would i go about changing all the '' to ' ?

thanks!