Announcement

Collapse
No announcement yet.

How do I search for blanks?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How do I search for blanks?

    Hi

    I need to find users that have not filled in specific fields in their profile, this is because we have only just started to make people fill these in, how can I search for a blank?

    Thanks

  • #2
    SELECT username FROM user,userfield WHERE user.userid=userfield.userid AND userfield.field#='';

    Change # to the field number you want to check.

    Comment


    • #3
      Thanks, but I was hoping to do it through the Control Pannel, is this possible?

      Comment


      • #4
        Not currently.

        Comment

        Related Topics

        Collapse

        Working...
        X