Create a phpmyadmin query to find and replace a value in Magento 1 database
Budget: €8 – €30 EUR
Hi everyone,
I am looking for a freelancer who can help me to adjust the prices in category texts and page texts by means of find and replace within sql (phpmyadmin) (so not of the products themselves, because they have already been adjusted).
For example:
Everywhere where "€0.90" is visible now, gets replaced by "€1".
I assume this can be done with a sql query.
I would like to receive your help with this. Afterwards I like to see the query so that I can apply it for other words and values.
During the work we first work on a test server, then we transfer the files to the live server.
My budget for this task is €20.
Thanks in advance for your help!
I am looking for a freelancer who can help me to adjust the prices in category texts and page texts by means of find and replace within sql (phpmyadmin) (so not of the products themselves, because they have already been adjusted).
For example:
Everywhere where "€0.90" is visible now, gets replaced by "€1".
I assume this can be done with a sql query.
I would like to receive your help with this. Afterwards I like to see the query so that I can apply it for other words and values.
During the work we first work on a test server, then we transfer the files to the live server.
My budget for this task is €20.
Thanks in advance for your help!