<div>
Pls trs this ..<br />
<br />
<br />

<pre><code id="code-20-41804612-1">--

update table_name set column_name = replace(column_name, '  ', '-'); 

--</code></pre>
<br />
--
</div>


Pls trs this ..




--

update table_name set column_name = replace(column_name, '  ', '-'); 

--


--

<div>
Your solution is not working space remain and -- added
</div>


Your solution is not working space remain and -- added

<div>
@Author - Any update on this ?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to adapt this Mysql query, this will be a manual query that I will run from PHPMyAdmin<br />
<br />

<pre><code id="code-10-28970738-1">update table_name set column_name = replace(column_name, ' ', '-'); </code></pre>
I want to replace consecutive space by only one &nbsp;-<br />
<br />
example<br />
report summer &nbsp; &nbsp; &nbsp;2016.pdf <br />
need to be change to report-summer-2016.pdf<br />
<br />
actual result report-this------2016.pdf<br />
<br />
Thanks
</div>
</div>


Hi,

I need to adapt this Mysql query, this will be a manual query that I will run from PHPMyAdmin

(CODE)
I want to replace consecutive space by only one  -

example
report summer      2016.pdf 
need to be change to report-summer-2016.pdf

actual result report-this------2016.pdf

Thanks

mysql query to adapt for a find and replace

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.