sql query to remove birthdays from user group

[andrewjs18]

hi all,

what would be the sql query that I can run to remove the birthdays from a specific user group?

[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.

[andrewjs18]

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!