MyBB Community Forums

Full Version: sql query to remove birthdays from user group
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
hi all,

what would be the sql query that I can run to remove the birthdays from a specific user group?
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.
(2013-10-02, 07:28 PM)Tankey Wrote: [ -> ]
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.

thanks!