SQL Query for Profile Field
 

Okay. I have a profile field to allow members to chose what header they use on my forum. The option is titled 'Show legacy header' - The default option is No. I've recently changed my branding so I want to force the original header to everyone, even those that have changed their header to the legacy header by chosing 'Yes'

What SQL query could I use to change this for everyone? To change their option set to 'No' ?

Thank you!

Greg

u cant get a aclear answer because nobody knows table's name and attribute but it should be similar to ;
update table xxxx set xxxx = 'No' ; // it does it for all and u may lose all ur saved data

I'm not really sure how I could be more clear. The profile field I wish to change is numbered 21. I'm sure I've seen it somewhere before? I wasn't aware there'd be a table that'd need changing.

Thanks though.

replace first xxxx with table's name and 2nd xxxx with fields title , More Info

How do I find out which table to change? Thank you!

Table should be userfield. If you have a prefix, then it would be prefixuserfield.

So, something like
As always, test this on your test site first and do a backup of your database before running ANY query.