Notifications
Clear all

wpForo 1.x.x [Closed] Is there any SQL command to change tags in the database, so all tags saying "super funny cars" become "funny cars"?

2 Posts
2 Users
1 Reactions
583 Views
Posts: 124
Topic starter
(@mplusplus)
Reputable Member
Joined: 4 years ago

Hi there

Is there any SQL command to change tags in the database, so all tags saying "super funny cars" become "funny cars"?

Thank you.

1 Reply
Tutrix
Posts: 1301
(@tutrix)
Noble Member
Joined: 4 years ago

@mplusplus

for table wp_wpforo_topics

 

update wp_wpforo_topics set tags =
replace(tags,'super funny cars','funny cars');

 

for table wp_wpforo_tags

update wp_wpforo_tags set tag =
replace(tag,'super funny cars','funny cars');