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" ?

http://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

Username:
Password:

Lost Password? Register now!

Who's Online

62 user(s) are online (30 user(s) are browsing Support Forums)


Members: 0


Guests: 62


more...

Donat-O-Meter

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

Latest GitHub Commits