Author Topic: Deleting fake email addresses after import (Read 904 times)

m.e. · April 09, 2010, 11:20:04 am

I had to create some fake email addresses in order to import contacts and contributions in a way that matched them. Now I'd like to get rid of the fake addresses, which had the format "fake<lastname>@example.com". I'm in the civicrm_email table in phpMyAdmin and I've done a query similar to

SELECT *
FROM `civicrm_email`
WHERE email LIKE 'fake%com'

and am seeing the results. Can I simply delete these records entirely to remove the fake addresses from these contacts?

Donald Lobo · April 09, 2010, 03:30:51 pm

yes

as always make a backup of the DB in case things go wrong

lobo

m.e. · April 12, 2010, 03:12:28 pm

I did back up, but that was unneeded. It worked like a charm. Thanks!

CiviCRM Community Forums (archive)

News:

Author Topic: Deleting fake email addresses after import (Read 904 times)

m.e.

Deleting fake email addresses after import

Donald Lobo

Re: Deleting fake email addresses after import

m.e.

Re: Deleting fake email addresses after import