<div>
Looks like your syntax is wrong. &nbsp;I used this in the SQL box and it worked fine. &nbsp;Change the table and column names to yours.<br />

<pre><code id="code-20-42172085-1">UPDATE `venues` SET `Venu_Name` = replace(`Venu_Name`, &quot;'&quot;, ' ') WHERE 1</code></pre>
</div>


Looks like your syntax is wrong.  I used this in the SQL box and it worked fine.  Change the table and column names to yours.


UPDATE `venues` SET `Venu_Name` = replace(`Venu_Name`, "'", ' ') WHERE 1

<div>
Relpace single quote with blank space.
</div>


<div>
<div class="content wysiwyg-content">
I have tried replace(myfield)=(myfield,<wbr />''',' ') which obviouslyy does not work<br />
<br />
Is there a mysql query that will replace all the ' with a space<br />
<br />
All from the myphpadmin interface?
</div>
</div>


I have tried replace(myfield)=(myfield,''',' ') which obviouslyy does not work

Is there a mysql query that will replace all the ' with a space

All from the myphpadmin interface?

Replace single quote (') with a space in a mysql field myphpadmin

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.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.