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

XF 1.3 SQL Query to Find Users with "Show User As Staff"

Discussion in 'XenForo Questions and Support' started by taylor_smith, Feb 22, 2014.

  1. taylor_smith

    taylor_smith Well-Known Member

    The SQL is not strong with this one. What query can I run to identify users with with the "show user as staff" box checked?
  2. Mike

    Mike XenForo Developer Staff Member

    SELECT * FROM xf_user WHERE is_staff = 1;
    taylor_smith likes this.

Share This Page