Inserting string values that contain a full bbcode link

[Sunka]

Need help for this sql
Problem is if I have link bbcode. How to insert string with bbcode link inside?

UPDATE
    xf_user_profile SI
SET
    SI.signature = '[I][COLOR=#404040][B]Ovo je defaultni signature (potpis)[/B][/COLOR][/I] - predstavljanje - [B][URL='https://www.pijanitvor.com/threads/kako-namjestiti.25213/']klikni me[/URL][/B]'
WHERE
    SI.signature = "";

 

[Sunka]

I found it my self.
Have to use escape character \ and double '

So query looks like this:

UPDATE
    xf_user_profile SI
SET
    SI.signature = '
[I][COLOR=#404040][B]Ovo je defaultni signature (potpis)[/B][/COLOR][/I] - predstavljanje - [B][URL=''https\://www.pijanitvor.com/threads/kako-namjestiti.25213/'']klikni me[/URL][/B]
'
WHERE
    SI.signature = "";