Jim R Posted February 4, 2010 Share Posted February 4, 2010 SELECT * FROM wp_1_posts WHERE post_content LIKE '[the-series before="<p>Read More About: " separator=" :: " after="</p>"]%' Basically, I want to delete everything between the LIKE and the % from my post_content column. It's a shortcode for WordPress, and I'd like to delete from the pages it's being use in. Is that possible? Link to comment https://forums.phpfreaks.com/topic/190878-i-only-want-to-delete-part-of-a-columns-information/ Share on other sites More sharing options...
Jim R Posted February 4, 2010 Author Share Posted February 4, 2010 Figured it out with help from this link: http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/ Link to comment https://forums.phpfreaks.com/topic/190878-i-only-want-to-delete-part-of-a-columns-information/#findComment-1006580 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.