SQL Query Needed

[Janota]

I want to run a query to set every user to a specific option of a custom field.

Ive added a "What mybb version are you using" custom field.

Options:
N/A
1.4
1.5
1.6
et......

I want to set every user to N/A if they hav'nt selected an option, any ideas?

[Polarbear541]

Replace 3 with the id of your field :p

Update mybb_userfields SET fid3='N/A' WHERE fid3='';

[Janota]

Hmmm , it didnt effect any rows "Affected rows: 0 (Query took 0.0004 sec)"

[Polarbear541]

Worked for me are you sure the existing ones are empty?

[Janota]

Yea there empty, heres a link to a random user : http://www.mybbextras.com/member.php?act...ile&uid=45

You'll see that the "Select your mybb version" field is empty

[Janota]

Any ideas why this query is not working ?

So annoying , works for fid3 but not for fid4

[Tim B.]

Can you print screen the mybb_userfields table so we can see what data is already there, please blur out any sensitive data.

[Janota]

Ok ive noticed something , it say NULL beside ID4

---

Yea that was the problem , got it now , thanks tim