Gossamer Forum
Home : Products : Gossamer Links : Discussions :

how to select specific users to email to

Quote Reply
how to select specific users to email to
under Links Admin / Email / Selected Users, what search input and wildcard character would I use to select only users with a validation code beginning with '14'? if i use '*' or '%' as wildcards or brackets it doesn't work and if i use just '14' it returns the list of all users with '14' anywhere in their validation code, not just the beginning of it. the only choices offered are 'Like, Exact Match and Not Equal'

i'm trying to do a search like this:
Code:
'14*'

Last edited by:

yo Huge: Sep 19, 2014, 2:59 PM
Quote Reply
Re: [yo Huge] how to select specific users to email to In reply to
Mmm the easiest way, would be to create a new field in the "Users" table called "DoEmail"

Then run a SQL query to update those users... so in your example, something like:

Code:
UPDATE glinks_Users SET DoEmail = 0; # reset any past ones!
UPDATE glinks_Users SET DoEmail = 1 WHERE Validation LIKE '14%'

Then search for them based on that field :)

Hope that helps

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!