Add DB Userfield Values

[dillon]

I added a custom userfield (field5) with radio buttons for male/female. I've already got a bunch of existing members. What is some simple sql that'll fill all of the values with "Male". I don't want to have to edit each user and add that manually.

Thanks.

[Link14716]

UPDATE userfield SET field5 = 'Male';