Your post doesn't make it clear exactly how you're accessing your MySQL database. The generally accepted way of doing this is with the DBD::mysql driver for the DBI module. If you use placeholders for your data, you don't need to worry about things like escaping quotes.

_______________
DamnDirtyApe

Those who know that they are profound strive for clarity. Those who
would like to seem profound to the crowd strive for obscurity.
            --Friedrich Nietzsche