No it can’t.
You effectively have 2 choices:
1- Ask someone to write the necessary sql query for you (or find something on the net)
2- Export the table containing the data you need to alter, run a search/replace on the data using a good text-editor, then reimport the table.
That’s it I’m afraid – is it something important / crucial ?
Thread Starter
Anonymous
I’m going to go with the text editor thing. For future notice, is there another software besides GM and MT that can do it? They have to rebuild and I hate that!
I honestly don’t know.
I do know that just for fun – and on a test blog – I have exported, changed, and imported data without error several times.
I use PSPad as my text editor of choice.
Nothing I can remember off the top of my head, but adding this to WordPress should be easy enough, if one has the time and inclination.
Don’t know if anyone is monitoring this thread… but I wrote a Search and Replace plugin that is essentially an SQL UPDATE (i.e. what is being dicussed here). You can get it from here or from wp-plugins.net
