XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / SQL command for changing text
Register
1
limecity
SQL command for changing text

  • 2010/5/12 5:30

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


I got 343 post in a forum thread. (newbb module)

and I need to change 343 of the titles of the posts.

how do i go about without manual editing 1 by 1 through the admin interface.

is there any command in mysql that i can use to change text "aaa" to text "bbb" ?

hhttp://www.mounthiking.com
all your hiking gears and gadgets

2
ghia
Re: SQL command for changing text

  • 2010/5/12 8:03

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Use something lijke
UPDATE table SET title = REPLACE(title,'fromaaa','tobbb') WHERE ...
Make a backup before.
Test the where clause with a
SELECT * FROM table WHERE ..

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

180 user(s) are online (99 user(s) are browsing Support Forums)

Members: 0

Guests: 180

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits