Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 4200
Latest: [chrisB]
New This Month: 4
New This Week: 1
New Today: 1
Stats
Total Posts: 42599
Total Topics: 7433
Most Online Today: 103
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 2
Guests: 67
Total: 69

Author Topic: Finding and deleting word from database  (Read 2247 times)

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 663
    • View Profile
    • Homework Clinic - Your Academic Lifeline
Finding and deleting word from database
« 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.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16155
    • View Profile
Re: Finding and deleting word from database
« Reply #1 on: March 14, 2016, 08:21:19 am »
Example backup before you run it
Code: [Select]
UPDATE tablename set columname = REPLACE(columname,  '$find', '$replacewith')
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/
Like Like x 1 View List

Offline shuban

  • Hero Member
  • *****
  • Posts: 663
    • View Profile
    • Homework Clinic - Your Academic Lifeline
Re: Finding and deleting word from database
« Reply #2 on: March 14, 2016, 11:38:39 am »
Thank you, it worked

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 16155
    • View Profile
Re: Finding and deleting word from database
« Reply #3 on: March 14, 2016, 11:48:04 am »
Glad to help
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
8 Replies
7809 Views
Last post October 14, 2006, 01:59:02 pm
by SMFHacks
2 Replies
3684 Views
Last post July 30, 2008, 03:41:08 pm
by fussilet
0 Replies
2502 Views
Last post February 16, 2009, 03:42:13 pm
by GadgetGeek
2 Replies
4549 Views
Last post July 09, 2016, 03:28:39 pm
by shuban
4 Replies
5123 Views
Last post July 11, 2016, 12:50:54 pm
by shuban

+- Recent Topics

Errors with SMF2WPBridge by [chrisB]
Today at 10:16:59 am

Undefined index: id by SMFHacks
Today at 09:41:30 am

Permissions query by davejo
Today at 01:31:46 am

"Notify all store admins of item purchase" Not Working in SMF 2.1.2 or 2.1.3 by Michael Vail
Today at 01:02:34 am

Additional Recommendations for SMF Store by Michael Vail
November 26, 2022, 12:49:58 pm

SMF Store 5.0 Beta Errors - Trying to access array offset on value of type null by Michael Vail
November 26, 2022, 12:07:42 pm

Modification: Subcategories total in main gallery view by VisiGod
November 26, 2022, 11:27:34 am

Change log for Downloads Pro 6.13 and 6.14 by Nicole
November 20, 2022, 08:24:34 am

Release date? by SMFHacks
November 20, 2022, 08:09:10 am

Can't install due to missing file? by SMFHacks
November 18, 2022, 06:55:45 pm

Powered by EzPortal