<div>
How big is this table? &nbsp;If it is less than a few million lines and you do not have to do this every few seconds, you might want to consider a PHP + MySQL solution.<br />
<br />
Also, &quot;I get an error.&quot; is not a standard message that I recognize. &nbsp;We can have a better chance of helping you if you show us the inputs, your code, the outputs and tell us about your desired outputs.<br />
<br />
Best regards, ~Ray
</div>


How big is this table?  If it is less than a few million lines and you do not have to do this every few seconds, you might want to consider a PHP + MySQL solution.

Also, "I get an error." is not a standard message that I recognize.  We can have a better chance of helping you if you show us the inputs, your code, the outputs and tell us about your desired outputs.

Best regards, ~Ray

<div>
&quot;I did not provide the exact error message, because it was not relevant to the solution.&quot;<br />
<br />
Wow, I wish the developers who write software could know they were wasting their time working on error messages. &nbsp;Think of the time we could all save if we didn't need the error messages!<br />
<br />
;-)<br />
<br />
~Ray
</div>


"I did not provide the exact error message, because it was not relevant to the solution."

Wow, I wish the developers who write software could know they were wasting their time working on error messages.  Think of the time we could all save if we didn't need the error messages!

;-)

~Ray

<div>
<div class="content wysiwyg-content">
I need to do a find and replace mysql statement.<br />
<br />
I wrote this statement to replace the odd characters with a single quote in table jos_content and row fulltext.<br />
<br />
update jos_content set fulltext = replace(fulltext, 'â¬&quot;', '\'') <br />
<br />
I get an error. I have tried finding the html entities for each of the three characters and replacing them but still get an error. Anythoughts?<br />
<br />

</div>
</div>


I need to do a find and replace mysql statement.

I wrote this statement to replace the odd characters with a single quote in table jos_content and row fulltext.

update jos_content set fulltext = replace(fulltext, 'â¬"', '\'') 

I get an error. I have tried finding the html entities for each of the three characters and replacing them but still get an error. Anythoughts?



MySQL Find and Replace Characters

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

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.