Hi,
I think this is a general question for people running MU:
I'd like to change in all blogs the standard-cat "uncategorized" in "somethingelse" and really don't want to do this one by one via phpmyadmin.
Which query do I need to change this for every single blog?
thx, Bruz
well you could run it through phpmyadmin saying: replace every uncategorized with categorized,its not one by one, its just one run :-)
I think you'd need one query per table, which is the why of Bruz's question.
You'll need a script to do it.
Ovidiu: yea, thats what I want - but HOW? :-) and
quenting: you're right - I'd like to do it db-wide. I think Ovidiu got the point, but I need the HOW :-)
I might make a complete idiot out of myself, but wouldn't a plugin like this do what you want: http://www.urbangiraffe.com/plugins/search-regex
mind though I did not test it, I just knew about it and there are several others doing the same thing, like: http://thedeadone.net/software/search-and-replace-wordpress-plugin/