Lengkap

Update mysql table where field contains...

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 ???

Kemahiran: MySQL, SQL

Lihat lagi: cron script perl update mysql table, update mysql table csv upload, update mysql table using cvs file, update mysql table webpage, using asp update mysql table, update mysql javascript field, php update mysql table script, update mysql table joomla, mysql table field php, update mysql table xml file, update mysql table data feed, php jquery update mysql table, jquery update mysql table, oscommerce add mysql table field, update mysql table rss feed

Tentang Majikan:
( 18 ulasan ) Wien, Austria

ID Projek: #22418953

Dianugerahkan kepada:

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 Lagi

€20 EUR dalam sehari
(22 Ulasan)
5.0
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. Lagi

€20 EUR dalam sehari
(12 Ulasan)
3.0

15 pekerja bebas membida secara purata €24 untuk pekerjaan ini

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 dalam 0 hari
(199 Ulasan)
7.3
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 dalam sehari
(30 Ulasan)
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 yo Lagi

€19 EUR dalam 2 hari
(7 Ulasan)
4.4
BestPrince1120

Greetings!! I have read your requirements carefully and i found my self fit in order to complete this project I Have vast experience in development and i have also made same kind of web application on same platform s Lagi

€30 EUR dalam sehari
(13 Ulasan)
3.7
eujinong

Dear sir. I am an expert of MySQL Database expert with good skills and rich experience. For about 8 year, I have built and customized many websites including MySQL databases. I have mastered in SQL queries and database Lagi

€30 EUR dalam sehari
(10 Ulasan)
4.4
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 Lagi

€20 EUR dalam sehari
(1 Ulasan)
3.7
Martiny

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

€34 EUR dalam 5 hari
(3 Ulasan)
3.1
jayprihar69

Greetings from Imenso Software Solutions, We are an established IT Development agency working since last 10 years. As per your requirement we have an experienced & reliable in house team to work with you on this requi Lagi

€19 EUR dalam 7 hari
(1 Ulasan)
3.3
imranulhasn

Hi I am free here for your project and can start immediately. I read your ☑️ Project description and I am confident that no one can do better than me with this project. ✅See Some of my recent completed project bell Lagi

€30 EUR dalam 2 hari
(4 Ulasan)
2.9
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 fie Lagi

€19 EUR dalam 7 hari
(3 Ulasan)
1.8
mihalceageorgica

I have more than 5 years experience with java, java EE, Spring etc. I have also a full time job as java developer

€25 EUR dalam 7 hari
(0 Ulasan)
0.0
elenasofiatop

Hi, How are you doing today? Being an expert in this field, I really know well about all features of the project what you want. As always, I'll provide best way and the results what you can completely finish this proje Lagi

€15 EUR dalam sehari
(0 Ulasan)
0.0
elitemobile888

Hi, best regards client! I read carefully your job posting. ~~~~ I can finish PERFECTLY your project within SHORT TIME on your SCREEN. ~~~~ I am a new freelancer, so I wanna not aim money and then I wanna good review Lagi

€19 EUR dalam 7 hari
(0 Ulasan)
0.0