| Re: SQL command for changing text |
| by ghia on 2010/5/12 8:03:47 Use something lijke le="color: #000000"><?php UPDATE table SET title = REPLACE(title,'fromaaa','tobbb') WHERE ... Make a backup before.Test the where clause with a le="color: #000000"><?php SELECT * FROM table WHERE ..
|
| SQL command for changing text |
| by limecity on 2010/5/12 5:30:32 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" ? |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|