The Rich Editor was replacing the characters
Code: Select all
'<' with #ed_op# and '>' with #ed_cl#
So now my new bb3 posts are filled with all those #ed_op#.
From my phpadmin, I can do an update on a row like this:
Code: Select all
UPDATE phpbb_posts
SET
post_text=REPLACE(post_text, '#od-op#', '<'),
post_text=REPLACE(post_text, '#od-oc#', '>')
WHERE post_id=xxxx;
I would like a query to loop through the table, 2000 records at a time and make all the changes without connection issues. (I will later convert those to bbcode too. )
Can someone suggest the most efficient way to do this? Need help.
Thanks a bunch.