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

[kingding]

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?

 

[skypeleft]

use plugin Hide My WP

 

[kingding]

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

 

[skypeleft]

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

you can try css guy

.imageclass {
     cursor: inherit !important
}

or here you go: https://wpmudev.com/blog/hide-media-attachment-pages-wordpress/

 

[kingding]

you can try css guy

.imageclass {
     cursor: inherit !important
}

or here you go: https://wpmudev.com/blog/hide-media-attachment-pages-wordpress/

That's a little closer, but I actually want to hard code out the <a> tags. My posts are available to read within an app, so a plugin won't be suitable because the app pulls the actual post html from the database.