Facebook  Twitter 

SMFHacks.com

+-

SMFHacks.com

+- User Information

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

+- Forum Stats

Members
Total Members: 11805
Latest: DebT
New This Month: 1
New This Week: 1
New Today: 1
Stats
Total Posts: 41608
Total Topics: 7274
Most Online Today: 65
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 28
Total: 28

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

0 Members and 1 Guest are viewing this topic.

Offline shuban

  • Hero Member
  • *****
  • Posts: 662
    • 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: 15753
    • 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: 662
    • 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: 15753
    • 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
7562 Views
Last post October 14, 2006, 01:59:02 pm
by SMFHacks
2 Replies
3404 Views
Last post July 30, 2008, 03:41:08 pm
by fussilet
0 Replies
2337 Views
Last post February 16, 2009, 03:42:13 pm
by GadgetGeek
2 Replies
4264 Views
Last post July 09, 2016, 03:28:39 pm
by shuban
4 Replies
4787 Views
Last post July 11, 2016, 12:50:54 pm
by shuban

+- Recent Topics

Thanks mod SMF 2.1 by Monocero
November 27, 2021, 01:13:01 pm

How to change the font on a photo in SMF Gallery Pro? by SMFHacks
November 18, 2021, 09:28:11 am

Bulk Upload Many Pictures - File Name by SMFHacks
November 17, 2021, 08:58:50 am

Schedule or direct download link by SMFHacks
November 16, 2021, 10:57:33 am

Download Expire by Vincent Volmer
November 16, 2021, 02:40:47 am

prettyurls - TroubleShooting.wiki by SMFHacks
November 14, 2021, 02:18:59 pm

Error With Delete Download by mickjav
November 10, 2021, 04:49:12 pm

No ads on left or right by coyote
November 08, 2021, 04:57:13 pm

Now accepting Cryptocurrency by SMFHacks
November 05, 2021, 05:33:27 pm

Latest Version Pretty Urls SEO Pro by SMFHacks
November 04, 2021, 03:46:53 pm

Powered by EzPortal