Is there an sql code or something to allow me to quickly prune the old and no longer relevant customers from my database? I've got several thousand on there, going back to 2010, and what with gdpr, people moving house or changing email, efficiency and general jurisprudence and so forth I could probably do with deleting anyone who hasn't logged into their account in a few years as the data will be out of date anyway.
I can't believe that i will literally have to manually delete each and every account via the Admin - there must be a database query of some sort that I could apply? One that would delete people with, say, last log in before 2016 or no log in at all (blank entry)?
Any help appreciated!
ta
Andy
v 1.5.6
Bookmarks