it's not a problem ##

##

    SELECT * FROM foo WHERE bar LIKE 'it's not a problem'

##

##

    SELECT * FROM foo WHERE bar LIKE 'it\'s not a problem'

##

##

    SELECT * FROM foo WHERE bar LIKE 'it''s not a problem'

##

##

    $str =~ s/'/''/g