XF 1.3 links in signatures

Is there a way in Xenforo to search my members and come up with a list of what users have links in their signatures? I am looking for a way to audit and get rid of site linking bots.


Formerly CyclingTribe
If it helps this SQL query should find all users who have a signature and which also contains http somewhere in the text:

SELECT * FROM `xf_user_profile` WHERE `signature` != '' AND `signature` LIKE '%http%';