Query assist

[beerForo]

Need to change these

[sharedmedia=core:attachments:1234]

to these

[ATTACH]1234[/ATTACH]

respectively (number-wise)

Thanks if you can help!

 

[beerForo]

My best guess

UPDATE 'table_name' SET 'field_name' = replace(same_field_name, '[sharedmedia=core:attachments:', '[ATTACH]')

and

UPDATE `table_name` SET 'field_name' = replace(same_field_name, ']', '[/ATTACH]')

 

[Paul B]

You will have to use regex as there is no way of matching the ] just for those strings.

If you do this -- UPDATE `table_name` SET 'field_name' = replace(same_field_name, ']', '[/ATTACH]') -- it will update every bb code in the post table with a closing ] to [/ATTACH].

 

[beerForo]

Oh yes that was silly. How do I do regex?

 

[Paul B]

If it's for the XF post table, with this add-on:

Post Content Find / Replace

This is a direct port of the original Post Content Find / Replace add-on for XF 1.x. You may wish to search the original resource discussion for solutions to common tasks performed with this add-on.

xenforo.com

 

[beerForo]

I have that add-on, no idea how to use it unfortunately.

 

[Paul B]

Post in the resource thread - someone should be able to help with crafting the regex required.

 

[beerForo]

Good idea!