<div>
<b>Actually accidentally in the first line between wp &amp;&nbsp;postmeta you have add a dash instead of put an underscore.<br />
<br />
The code is working 100%, thank you very much Walter Ritzel, appreciate for your time.<br />
<br />
This is the code:</b><br />

<pre><code id="code-20-39975256-1">update wp_postmeta
set meta_value = SUBSTR(CONVERT(CONVERT(REPLACE(META_VALUE,'.',''),DECIMAL(16))/100.00,CHAR),1,LENGTH(CONVERT(CONVERT(REPLACE(META_VALUE,'.',''),DECIMAL(16))/100.00,CHAR))-2)
where meta_key = 'price';</code></pre>
</div>


Actually accidentally in the first line between wp & postmeta you have add a dash instead of put an underscore.

The code is working 100%, thank you very much Walter Ritzel, appreciate for your time.

This is the code:


update wp_postmeta
set meta_value = SUBSTR(CONVERT(CONVERT(REPLACE(META_VALUE,'.',''),DECIMAL(16))/100.00,CHAR),1,LENGTH(CONVERT(CONVERT(REPLACE(META_VALUE,'.',''),DECIMAL(16))/100.00,CHAR))-2)
where meta_key = 'price';

<div>
<div class="content wysiwyg-content">
I need an sql query to search &quot;wp_postmeta&quot; table for rows with meta_key &quot;price&quot; and meta_value more than 1 thousand (eg 1.084.51) and delete the first dot of the meta_value.<br />
before: 1.084.51 -&gt; after: 1084.51<br />
I dont know if it is possible to do this with an sql query, anyway I hope it is possible.<br />
<br />
Here is a picture: <br />
<a href="https://filedb.experts-exchange.com/incoming/2014/04_w14/843019/price.jpg" target="_blank" title="price (206 KB)"><img alt="price" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2014/04_w14/800_843019/price.jpg" /></a><br />
<br />
Thanks in advance, Nicolas...
</div>
</div>


price.jpg

I need an sql query to search "wp_postmeta" table for rows with meta_key "price" and meta_value more than 1 thousand (eg 1.084.51) and delete the first dot of the meta_value.
before: 1.084.51 -> after: 1084.51
I dont know if it is possible to do this with an sql query, anyway I hope it is possible.

Here is a picture: 



Thanks in advance, Nicolas...

Help, need phpmyadmin sql query for search &amp; edit/delete

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

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.

WordPress

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.

Help, need phpmyadmin sql query for search &amp; edit/delete

Help, need phpmyadmin sql query for search & edit/delete