How to mass prune bbcode tags via query

[Axiom]

Hi folks,
I want to remove all "hide" tags, and all between them, from a lot of posts into my board. How can i do that? usually those tags are used with "url" tags into:

[ hide ] [ url=blablabla ] some text [ /url ] [ / hide ]

I want to delete those kind of rows.

Thanks,
Luca