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? Quote 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/ Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.