XF 2.0 Use Batch Update Users to search for users with website

[KevinMK]

Is there a way to use the form for Batch Update Users to search for users who filled in a specific field under Personal details? I'd love to search for people who have filled out the website field.

Can you use regex?

 

[KevinMK]

I just realized that there isn't even a field for it. Perhaps I'll need to use a SQL query.

 

[Mr Lucky]

There is a good add on for this

Member search

Premium upgrade: This XF2 add-on along with the entire collection can be purchased for $35.00 USD. Your Premium upgrade will allow you to download as many XF2 add-ons as you like for one year. Please see the entire collection located in the...

xenforo.com

 

[nocte]

This SQL query gets all users with a website for you:

SELECT `xf_user`.`user_id`, `xf_user`.`username`, `xf_user_profile`.`website` FROM `xf_user` LEFT JOIN `xf_user_profile` ON `xf_user`.`user_id` = `xf_user_profile`.`user_id` WHERE `xf_user_profile`.`website` != ""

It fetches only username, user_id and website.

I would not use raw SQL queries in order to delete users - you would have orphaned data in your database!