MyBB Community Forums

What query will i have to run for this, Basically before i changed gender to a required field, people selected undefined which i have now removed. What SQL Query will i have to run to make everyone male until they can change it.

Thank you!

Reece.

UPDATE `mybb_userfields` SET fidX = 'Male' WHERE fidX = 'undefined'

Replace X with the actual ID obviously.

Thank you