SMFHacks.com

Modifications/Themes => General SMF Forum => Topic started by: shuban on March 14, 2016, 12:24:12 am

Title: Finding and deleting word from database
Post by: shuban on March 14, 2016, 12:24:12 am

Hi,

I would like to find the words: "[hide]" and "[/hide]" from all posts made in my database and replace them with nothing.

What mysql trick in PHPmyadmin can I use to do this quickly? I have >1 million posts.

Title: Re: Finding and deleting word from database
Post by: SMFHacks on March 14, 2016, 08:21:19 am

Example backup before you run it

Code: [Select]

UPDATE tablename set columname = REPLACE(columname,  '$find', '$replacewith')


Title: Re: Finding and deleting word from database
Post by: shuban on March 14, 2016, 11:38:39 am

Thank you, it worked

Title: Re: Finding and deleting word from database
Post by: SMFHacks on March 14, 2016, 11:48:04 am

Glad to help