Remove media links from WP post media | Is SQL the best way?

kingding

Member
Aug 17, 2019
52
22
8
In my wordpress posts, some images are clickable and some are not. When they are clicked, they open a new page. I do not want any clicking & url behaviour.

I could go through every single post in the backend, click every image, and disable each media link... but that would take years! My best thought is to do an SQL query to remove any instance of <a></a> from divs with the wp-block-image class.

Essentially...
- IF "<a href="https://wordpress: ... " exists after "<figure class="wp-block-image">", then delete "<a ... >"
- IF "</a>" exists after "<img src="https: //wordpress- ... >", then delete "</a>"

Unless of course you have a better idea than SQL? 🤔
 

Attachments

kingding

Member
Aug 17, 2019
52
22
8
use plugin Hide My WP

Thanks, but that doesn't seem relevant. Maybe there's a feature in there that can do this, but it's a whole security plugin which is overkill. I need a permanent solution that will actually alter the wp_post 👍
 

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu