Hello,
I need some help with a MySQL command.
I try to find all active users that have eg "@domain.com" email address.
Any help?
Thank you in advance,
Iro
Try this one
SELECT * FROM cwd_user where active = 1 AND email_address LIKE '%@domain.com'
Please try
select user_name from cwd_user where active=1 and email_address like '%@domain.com%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks you both.!
Just found it:
SELECT DISTINCT cwd_user.lower_user_name, cwd_user.display_name FROM cwd_user WHERE cwd_user.lower_email_address like '%domain.com' AND cwd_user.active = 1;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.