$str = $dbh->quote("%it's not a problem%");

print "<p>quoted: $str</p>";

##</code><code>##

$sth = $dbh->prepare(
"SELECT name FROM practice WHERE name LIKE '%it\'s not a problem%' "
) || die "Error: " . $dbh->errstr;

##</code><code>##

$sth = $dbh->prepare(
"SELECT name FROM practice WHERE name LIKE '%it''s not a problem%' "
) || die "Error: " . $dbh->errstr;