XF 1.5 Locating account with no emails

[Blitzz]

How would I go about pulling up all the accounts with no registered emails under the account.

I've created a lot of test accounts for testing. Too many to count and would like to remove all of them.

 

[Paul B]

Using phpMyadmin to identify the accounts would likely be the easiest way - then delete them via the UI in the ACP.

 

[Mouth]

Using phpMyadmin

select username from xf_user where email = '' or email is null or email not like '%@%';