Update mysql table where field contains...

€8-30 EUR

Finalizat

Data postării:

peste 4 ani în urmă

€8-30 EUR

Plata la predare

I have a table with ocr data from facebook and twitter. the ocr_text field contains the data from posts. I need to update the date field with the date from the ocr_text field. The ocr_text field looks like this: Peter Pilz 26. September • G Offener Brief an Pamela Rendi-Wagner: BEI EXTREMISTEN BLEIBT MAN NICHT SITZEN! Sehr geehrte Frau Parteivorsitzende, liebe Pam!... Mehr anzeigen @366 78 Kommentare 66 Mal geteilt or Peter Pilz 25. September • G HUNGERHILFE FUR STRACHE, KICKL UND KURZ Für die Flüchtlingshilfe des World Food Programmes vor Ort in Jordanien und im Libanon hatten die drei 2018 genau 1,8 Millionen Euro. So Viel haben Strache, Kickl und Kurz allein gekostet. Mehr anzeigen [login to view URL] Schau gemeinsam mit einer Gruppe Oder Freunden zu 001.263 Watch Party starten 593 Kommentare 342 Mal geteilt or Peter Pilz 27. September • G ZÖPFERLDIKTATUR? "Klimakriegsrecht! Zöpferldiktatur!" Norbert Hofer beschimpft Klimaschützer.... Mehr anzeigen LIVE @ JETZT WAH 19 203 Kommentare 108 Mal geteilt 745 or Peter Pilz 28. September • G ES GEHT I-JM 7 MANDATE! Es wird knapp. Ganz knapp. Jede Stimme entscheidet. Und diesmal gibt es nur eine Wahl:... Mehr anzeigen Deine Stimme für 275 JETZT Mandate 64 Kommentare 41 Mal geteilt Its always the same: The date is from 1. August to the 29. September. script should be: update ocr set date = "2019-09-28" where ocr_text ???

MySQL

SQL

ID-ul proiectului: 22418953

Despre proiect

11 propuneri

Proiect la distanță

Activ: 4 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

Acordat utilizatorului:

@nicrosoft

Hi there, Thank you for sharing your requirement. Hope you are doing good and having a nice day. I'll design your Query as you have mentioned in details on urgent basis. Please feel free to contact me. I have many years of experience in website and database with rich knowledge of web and database technologies like ASP.NET C#, MSSQL, PHP, HTML, CSS, Bootstrap, JavaScript, Payment methods integrations. Web hosting at Azure, AWS, Plesk, Godaddy etc. I would like to have a detailed discussion with you on this project in order to better understand the project specifications. Kindly Inbox me so we can discuss and start the project. I will Provide you Unlimited Revisions. Looking forward to hear from you soon. My portfolio is here https://www.freelancer.com/u/nicrosoft My Services ◆ Communication for every day and delivery good quality source code. ◆ Maintaining for a month after development. Here is my past works. ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] Admin Panels are here (Ping me for admin credentials) ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] ◆ [login to view URL] Best Regards, Malik Farhan A.

€20 EUR în 1 zi

5,0

(31 recenzii)

5,2

@MimiFL

Hello, i believe this can be completely automated, so you don't need 60 different statements from 1 Aug to 29 Sep. The date can be automatically detected and converted to correct format, with a single UPDATE statement. If you are interested in working with me, feel free to message me and i will try to help immediately. Thanks, Milan

€20 EUR în 1 zi

5,0

(12 recenzii)

3,1

11 freelanceri plasează o ofertă medie de €24 EUR pentru proiect

@sumon355

Hello, I think the query should be like this : update ocr set date = "2019-09-28" where ocr_text like '%28. September%' Please let me know if it works and need any more help! Thanks

€19 EUR în 0 zi

5,0

(213 recenzii)

7,4

@umairmalik10

Hi, I've checked your given task and I can make a query script to update that data as per date in string. Please msg me so we can discuss. thanks

€35 EUR în 1 zi

4,9

(32 recenzii)

5,1

@dreammate0621

Hello! I am a web developer. I've read your job description with great interest. I've fully understood what you want and if you hire me, you would get the best result. I can start work immediately and can chat with you anytime in your timezone. I will wait for your reply. Thank you.

€19 EUR în 2 zile

5,0

(8 recenzii)

4,5

@khyatitankariya

Hello, I got your point still like to confirm the exact text I have to update the date field for. I am an experienced PHP application developer and working as a freelancer full time. Please message me so that we can discuss project details and i will complete this as soon as possible. Thank you!

€20 EUR în 1 zi

5,0

(1 recenzie)

4,0

@Martiny

Greetings. I can solve your task in time. I have experiance in data scraping and data Base design and development.

€34 EUR în 5 zile

4,9

(3 recenzii)

3,1

@taijin95

Hello. I have read explanation of your project in details. I have rich experiences in website development, so I can provide you best work. As you can see in my background, I have much experience and assets in this field. So, if I add some modification to that, you can surely get you want. You will get to know another trustworthy and talent programmer by choosing me and I will be honored to complete another task-perfectly. In particular, I will be honored to make this project successful for a nice customer. Thanks Regarding

€19 EUR în 7 zile