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.
Маємо в базі url який потрібно замінити за шаблоном.
Старий url - https://oldsite.imgix.net/app/uploads/2019/10/04151252/edreports.jpg
Новий url - /uploads/2019/10/edreports.jpg
Потрібно прибрати "https://oldsite.imgix.net/app" та "/04151252". Але проблема в тому що "/04151252" це унікальний ідентифікатор, тому потрібна регулярка.
Таблиця wp_postmeta, колонка meta_value. Значення може повторюватись декілька разів в одній ячейці, тому що там записується масив але як стрінга.
Client's feedback on cooperation with Dmytro Butko
SQL requests with regularityEverything is great, Dmitry has done it very quickly. A lot of thanks!
Freelancer's feedback on cooperation with Nazarii K.
SQL requests with regularityI recommend the collaboration, the customer knows what he needs.
-
1862 72 5 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
можу написати запит зараз, зроблю швидко і якісно, від вас треба буде доступ в БД або самі зможете виконати sql
upd: запит вже написав, пишіть в повідомлення
-
1157 7 0 Сделаю
-----------------------------------------------------------------------
-
2416 71 0 Welcome to. Please write in the message. This can be even easier to do in php than regularly in mysql.
Вітаю. Напишіть, будь ласка, в повідомлення. Це може бути навіть простіше зробити на php, ніж регуляркою в mysql.
-
1430 34 1 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!
Вітаю
Не обіщаю що це буде на регулярні но задачу можу викона
Ціна 600грн
Звертайтесь!
-
3029 379 7 1 I am ready to write a script that transforms the table.
=-===========================================================================================================================================================================
Готов написать такой скрипт который переделает таблицу
=-=- = -= -= -= -= -= -= -= -= -= -= -=- =- = -=-
Current freelance projects in the category Databases
Development of database architecture
501 USD
Database Architecture Development Description: We are looking for an experienced database architect to conduct an analysis of our current database architecture and develop recommendations for its improvement. Our goal is to optimize performance, ensure scalability, and enhance… Databases ∙ 5 proposals |
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 6 proposals |
Set up the transmission of the array rro_info in payments from the WordPress website
25 USD
Implement the transfer of the rro_info array via API in order to fiscalize payments using the LiqPay payment aggregator. A mandatory condition for fiscalization is the presence of data on the goods for which the payment is made. To transfer data on goods in the Liqpay request… Databases, Web programming ∙ 1 proposal |
Online store improvement!!! Please, experience with OpenCart 3 of 3 years !!! 1. **Performance optimization:** - Identification and elimination of performance bottlenecks in the store, such as slow database queries, inefficient algorithms, etc. 2. **Development and implementation of new… Databases, Web programming ∙ 2 proposals |
Extract data from CSV and export to Google Sheet
127 USD
Good day! It is necessary to extract data from about 10 csv files (each containing no more than 200 rows and 10 columns) of a specific format, process them, and export them to a google sheet according to a template. I will provide the original csv files to the final developer… Python, Databases ∙ 13 proposals |