<div>
UPDATE tablename SET `fieldname`=REPLACE(`field<wbr />name`,&quot;'&quot;,<wbr />&quot;&quot;)
</div>


UPDATE tablename SET `fieldname`=REPLACE(`fieldname`,"'","")

<div>
hi<br />
<br />
that didn't remove them
</div>


<div>
Are you sure you supplied the correct value for tableName and filedname? From where are you submitting the query?
</div>


Are you sure you supplied the correct value for tableName and filedname? From where are you submitting the query?

<div>
perhaps I should give you the background.<br />
<br />
I have imported some urls into a database.<br />
<br />
when these urls are clicked, I get an error in the browser becuase link is incorrect. This what I get:<br />
/\&quot;<a href="http://www.mydomain.com/\" rel="ugc nofollow">http://www.mydomain.com/\</a><br />
<br />
So, I need to remove the stuff around the url (perhaps it isn't quotation?)<br />
<br />
really appreciate your help
</div>


perhaps I should give you the background.

I have imported some urls into a database.

when these urls are clicked, I get an error in the browser becuase link is incorrect. This what I get:
/\"http://www.mydomain.com/\ [http://www.mydomain.com/\]

So, I need to remove the stuff around the url (perhaps it isn't quotation?)

really appreciate your help

<div>
My first example was to remove single quotes since you posted this:<br />
'MY CONTENT'<br />
<br />
From your last post, it seems you need to remove double quotes<br />
UPDATE tablename SET `fieldname`=REPLACE(`field<wbr />name`,'&quot;',<wbr />&quot;&quot;)
</div>


My first example was to remove single quotes since you posted this:
'MY CONTENT'

From your last post, it seems you need to remove double quotes
UPDATE tablename SET `fieldname`=REPLACE(`fieldname`,'"',"")

<div>
hi <br />
tested but didn't work
</div>


<div>
How are you retrieving the data? Are you using PHP?
</div>


How are you retrieving the data? Are you using PHP?

<div>
this problem wasn't a db issue, but problem in program I was using. but thansk for help anyway
</div>


this problem wasn't a db issue, but problem in program I was using. but thansk for help anyway

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have content in a field in my mysql db which have quotes i.e :<br />
<br />
'MY CONTENT'<br />
<br />
I need an sql that will remove these quotes.
</div>
</div>


Hi

I have content in a field in my mysql db which have quotes i.e :

'MY CONTENT'

I need an sql that will remove these quotes.

remove quotes from field in mysql db

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.