SQL requests with regularity
Old url - https://oldsite.imgix.net/app/uploads/2019/10/04151252/edreports.jpg
New URL - /uploads/2019/10/edreports.jpg
You need to select "https://oldsite.imgix.net/app" and "/04151252". But the problem is that "/04151252" is a unique identifier, so you need a regular.
Table wp_postmeta, column meta_value. The value can be repeated several times in one cell because there is a massive but as a string.
Client's review of cooperation with Dmytro Butko
SQL requests with regularityEverything is great, Dmitry has done it very quickly. A lot of thanks!
Freelancer's review of cooperation with Nazarii K.
SQL requests with regularityI recommend the collaboration, the customer knows what he needs.
-
1400 76 6 3 I can write a query now, I will do it quickly and quality, you need access to the BD or you can perform the sql yourself
upd: the request has already been written, write in the message
-
2110 71 0 Welcome to. Please write in the message. This can be even easier to do in php than regularly in mysql.
-
1103 34 0 2 Welcome to
I don’t promise that it will be on a regular basis but I can do the task.
The price is 600g
Turn to!
-
2643 427 9 1 I am ready to write a script that transforms the table.
=-===========================================================================================================================================================================
Current freelance projects in the category Databases & SQL
Emails about orders and requests from the website are not coming.
16 USD
Diagnosis and resolution of the issue with email notifications on the OpenCart site is required. Currently, notifications are not being received via email for the following events: new orders; callback requests; comments left by users; questions and answers about products; other… C & C++, Databases & SQL ∙ 33 minutes back ∙ 6 proposals |
Resolve the loading issue on the PrestaShop website hostingThe website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable… PHP, Databases & SQL ∙ 4 hours 32 minutes back ∙ 18 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 6 hours 2 minutes back ∙ 17 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 8 hours 14 seconds back ∙ 33 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 9 hours 5 minutes back ∙ 8 proposals |