Announcement

Collapse
No announcement yet.

Specific Query request

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

  • Specific Query request

    Does anybody know what query I could run to delete all the users who are prefixed with "imported_" and that have 0 posts?

    This would save a lot of time merging users .. they have 0 posts, so why bother merging?..

  • #2
    Of the top of my head I would go with this to find them :

    Code:
    SELECT * FROM user WHERE username LIKE "imported_%" AND posts = 0;
    And to delete :

    Code:
    DELETE FROM user WHERE username LIKE "imported_%" AND posts = 0;
    I wrote ImpEx.

    Blog | Me

    Comment


    • #3
      Thank you!

      Comment


      • #4
        Originally posted by Jerry View Post
        Of the top of my head I would go with this to find them :

        Code:
        SELECT * FROM user WHERE username LIKE "imported_%" AND posts = 0;
        And to delete :

        Code:
        DELETE FROM user WHERE username LIKE "imported_%" AND posts = 0;
        Thanks

        Comment


        • #5
          Great post

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X