| View previous topic :: View next topic |
| Author |
Message |
BlueSquares
Joined: 11 Jul 2008
Posts: 12
|
 Posted: Wed May 19, 2010 3:18 pm Post subject: MySQL Query for Exporting Emails of Refunded Customers |
 |
|
I personally send out updated versions of my Wordpress PPC Theme to all my customers.
Thing is...I don't want refunded customers to get the updates.
So I developed this very simple query to pull all the emails of refunded customers so I can remove them from my GetResponse Product Update mailing list.
| Code: |
SELECT `email`
FROM `customers`
WHERE date LIKE (
'%refunded%'
)
|
Just paste in the above code in PHPMyAdmin's "SQL" tab. Then click "export" at the bottom of the results page and select your export options on the next page. I usually leave the default, check CSV and submit.
Unfortunately, I don't see a way for GetResponse to remove them in bulk. Suck-a-roni.
_________________
PHP Link Cloaker | Wordpress Salesletter Theme |
|
| Back to top |
|
 |
admin
Site Admin
Joined: 31 Jul 2005
Posts: 9134
Location: Australia
|
|
| Back to top |
|
|
|
FAQ
Search
Register
Profile
Log in to check your private messages
Log in
