MyBB Community Forums › Community Archive › Archived Forums › Archived Development and Support › MyBB 1.6 › 1.6 General Support v
sql query to remove birthdays from user group

Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Linear Mode
Solved: 11 Years, 3 Months, 4 Weeks ago sql query to remove birthdays from user group
Tankey Offline
Posts: 340
Threads: 79
Joined: Feb 2011
Reputation: 6
#2
Solved: 11 Years, 3 Months, 4 Weeks ago 2013-10-02, 07:28 PM (This post was last modified: 2013-10-02, 07:28 PM by Tankey.) 
UPDATE `mybb_users` SET `birthday` =  '' WHERE `usergroup` = 'USERGROUP_ID_HERE';

That will do the trick.

Make always a backup of your database when you run queries yourself, in case it goes wrong.
Find
Jump to the post that solved this thread.


Messages In This Thread
RE: sql query to remove birthdays from user group - by Tankey - 2013-10-02, 07:28 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)