User Profile Field - Few questions...

[Kaemon]

Originally Posted by Dismounted

By the way, do not try editing the fields in the database directly, it doesn't work that way.

woah. I was just about to do a database update. Can you clarify why I shouldn't or what I should do instead?

Let's say I have a custom profile field (field 9) called "Favorite Color" with a single-select dropdown and 2 options:
Red
Blue

After 500 users have registered, the userfield table will have a value of "Red" or "Blue" in column "field9".

If I want to change the color options to "Red" and "Green", couldn't I just update the userfield table by setting field9 to "Green" where field9 = 'Blue'?

Thanks for your help.