1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.3 Query to display members by year

Discussion in 'XenForo Questions and Support' started by Nudaii, Mar 11, 2014.

  1. Nudaii

    Nudaii Well-Known Member

    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
  2. Mike

    Mike XenForo Developer Staff Member

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

    Should work...
    Nudaii likes this.
  3. Nudaii

    Nudaii Well-Known Member

    thanks mike :)

Share This Page