Jump to content

Change multiple accounts


Recommended Posts

Does anyone know of a faster way to "change" multiple accounts from "Inactive" status to "closed" status, with out having to edit each account individually?


(maybe a sql script or something?)


I need to edit 6 pages of accounts and change them from inactive status to closed status, and trying to do that 1 account at a time is going to take forever. And the only option when "checking" the box beside each name is to "send message". (Would be nice if there was more options there)

Link to comment
Share on other sites

Try this:


UPDATE tblclients

SET status='Closed'

WHERE status='Inactive';


I confirmed the query works fine but it will close ALL accounts marked as Inactive. I would suggest you run the query on a non-production install first or, at the very least, backup your database before you run the query.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated