XF 2.2 Remove bold from signature after import

[Black Tiger]

I've set "Allow basic text formatting (bold, italic, etc)" to "never" for registerd users (so this will be applied to everyone).
However, after the ipb import, this was not changed, so several users have signatures in bold.

Is there an easy way, like a mysql query, to remove all bold from signatures?

 

[Paul B]

Untested but these queries should work.

UPDATE xf_user_profile SET signature = REPLACE(signature, '[B]', '');

UPDATE xf_user_profile SET signature = REPLACE(signature, '[/B]', '');