Help with SQL query after SMF > XF import

[Mr. Jinx]

I recently converted my forum from SMF to XF.
Could someone please help me wit an SQL command that can do this in the xf_posts table?

replace "domain.com/forum1/index.php?action=dlattach;topic=*;attach=#" with "domain.com/forum2/attachments/#/

for example:
domain.com/forum1/index.php?action=dlattach;topic=56382.0;attach=17975"

 

[fly]

Although I haven't actually looked (and pardon me if you have) the answer might already exist in this thread:

https://xenforo.com/community/threads/post-content-find-replace.6548/

 

[Mr. Jinx]

Thanks! That should do it.