UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support View by Homepage?

I'm trying to clean up our membership and have noticed a number of them have have homepages that are not desirable. Is there a way to search or list by homepage and then delete those members?

Thanks

This is a start:

SELECT * FROM ubbt_USER_PROFILE WHERE USER_HOMEPAGE = 'badhome'

Change badhome to the word you are looking for.

Thanks,

This would work if I knew the name but they are all different. I'd like to list members by their home page and check them and delete them if they look bad.

Steve