MYSQL Update Query to lowercase href links in post_content field of wordpress wp_posts table

I want a mysql update query that will replace all uppercase text contained within href links of the post_content field of all my wordpress posts with lowercase href links.

Let's say that I have this href link in my post_content field which contains some upper case characters see below

<a href="./attached_files/[url removed, login to view]" >

and I want to change it to all lowercase like below

<a href="./attached_files/[url removed, login to view]" >

I assume this will need a good knowledge of regex functions.

I cannot give you access to my database so you need to do your own testing

PLEASE NOTE : I do not want to lowercase the entire contents of the post_content field

Kemahiran: MySQL, PHP

Lihat lagi: regex in c, mysql characters, access query table, wordpress mysql query, mysql update field, access table query, mysql replace text, update wordpress database, wordpress table links, link wordpress access database, wordpress ajax add content post, php query link, access wordpress mysql, php good update, link access database wordpress, wordpress posts, wordpress content post installation, query posts wordpress, change href, custom wordpress post query

Tentang Majikan:
( 31 ulasan ) Bendigo, Australia

ID Projek: #7234339

Dianugerahkan kepada:


A proposal has not yet been provided

$10 AUD dalam sehari
(1 Ulasan)

6 pekerja bebas membida secara purata $24 untuk pekerjaan ini


A proposal has not yet been provided

$30 AUD dalam sehari
(697 Ulasan)

Hello! With 99% completion rate, 750 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u Lagi

$54 AUD dalam sehari
(559 Ulasan)

Hello sir, I read your requirements very-well and ready to start work from now. I can do this using javascript/jQuery. Hope you will give me a chance to do work with you, waiting for your reply, Thank you

$10 AUD dalam sehari
(112 Ulasan)

I ready to help you :) Regards, Alex

$25 AUD dalam sehari
(2 Ulasan)

I am capable of doing it really quickly (a few hours with testing included at max). Contact me if you are interested.

$10 AUD dalam sehari
(0 Ulasan)

i can do it very well, its just a conversation of all that link string to lower case. Thank You Kaushal Patel

$15 AUD dalam sehari
(0 Ulasan)