XF 1.2 How to query the database where the signature is stored?

[rdn]

So I'd like to search on the signature field of all my forum user's.
This bbcode [photo] was use by Xengallery addon.

I want to search if who else are using this code on their signature and modify them one by one.
I have 140K of user's and I think only a few are using the bbcode.

 

[Paul B]

SELECT * FROM xf_user_profile WHERE signature LIKE '%[photo]%'

 

[rdn]

Done, MySQL returned an empty result set (i.e. zero rows). (Query took 0.1385 sec)

Thanks