perlquestion
Cody Fendant
<p>I want to replace some things in MySQL fields.</p>
<p>Unfortunately those things are quotes.</p>
<p>So I have a statement like this:</p>
<code>UPDATE table_name SET `fieldname` = REPLACE(`fieldname`,'‘','''')</code>
<p>which replaces a "smart quote" type apostrophe with a regular one (MySQL's way of escaping a quote is to double it).</p>
<p>That statement you can see above works from the command line, but not if I use DBI's <code>do()</code> function.</p>
<p>Any suggestions? Any way in which I can pass in quotes without having problems with DBI quoting the quotes around the quotes?</p>
<p>Any other way to attack this problem?</p>