I'm doing a large import from Ikon - over 1.4 million posts.
I've figured out a lot, but I have text in posts that I need to cleanup. I've tried running cleaner.php. It gets to 800,000 posts fairly quickly, but after that, it just CRAWWWWLLLLS - after 24 hours, I was only at 1.1 million!
Anyway, here's one example that I'm trying to clean up:
I need to replace the above with:
[code][quote=[/code]
Can I do this with a SQL statement? If so, what would the syntax be?
I tried:
Just to see if I could find the rows, but it returned nothing...
Thanks!
--Omar
I've figured out a lot, but I have text in posts that I need to cleanup. I've tried running cleaner.php. It gets to 800,000 posts fairly quickly, but after that, it just CRAWWWWLLLLS - after 24 hours, I was only at 1.1 million!
Anyway, here's one example that I'm trying to clean up:
Code:
<div class="iF-Passage"><div class="QUOTEHEAD">Quote:(
[code][quote=[/code]
Can I do this with a SQL statement? If so, what would the syntax be?
I tried:
Code:
SELECT * FROM post WHERE pagetext LIKE '%<div class="iF-Passage"><div class="QUOTEHEAD">Quote:(%'
Thanks!
--Omar
Comment