XF 1.3 Query to display members by year

[Nudaii]

would there be a way to display all members who joined before x year via sql?

Aka members who joined before jan first 2012 etc

 

[Mike]

SELECT * FROM xf_user WHERE register_date < UNIX_TIMESTAMP('2012-01-01');

Should work...

 

[Nudaii]

thanks mike