- or download this
it's not a problem
- or download this
SELECT * FROM foo WHERE bar LIKE 'it's not a problem'
- or download this
SELECT * FROM foo WHERE bar LIKE 'it\'s not a problem'
- or download this
SELECT * FROM foo WHERE bar LIKE 'it''s not a problem'
- or download this
$str =~ s/'/''/g