We want to mask some set of emails , so we need to update Users table , the query worked week before but its not working now.
update users set email=concat(email,’_dev’) where city='Singapore'
Is that Job depricated aleady , any idea ?
Can you let us know how to mask bulk emails
Solved! Go to Solution.
Does it satisfies to any user ? Please run select query from data analyzer
select email from users where city='Singapore' and email not like '%dev';
if above query returns result then what is error in log ?
what is frequency of job ?
try adding semi colon in end