XF 1.3 Database Query Needed

[wickedstangs]

Did the SMF to Xenforo move and need a database query for Images..

All the images moved with

 

[wickedstangs]

Would it be something like this????

UPDATE my_db_name.xf_post
SET my_db_name.xf_post.message
= REPLACE (my_db_name.xf_post.message ,'[imgXXXXX]',' ')
WHERE my_db_name.xf_post.message like '[img]';

 

[AndyB]

You will want to use this add-on.

http://xenforo.com/community/resources/post-content-find-replace.1549/

 

[borbole]

Would it be something like this????

UPDATE my_db_name.xf_post
SET my_db_name.xf_post.message
= REPLACE (my_db_name.xf_post.message ,'[imgXXXXX]',' ')
WHERE my_db_name.xf_post.message like '[img]';

It would be best to use the mod linked by Andy above. But if you would rather run the query, try this:

UPDATE xf_post
SET message = REPLACE(message,'[img width=449 height=480]','[img]');