UBB.Developers Forums UBB.threads 7 Development How Do I? How to change one field on the database?

I hate when it happens to me.
I read someone else question about how to change one field at whole users database.
Was someting like changing "Visible" or "Email Notifications"... one of those Yes/No awnser at the end of each users profile.
Was a SQL command to change all users to one kind of awnser.
Well, I lost it, and I used the Search and still didn't find it.
There is any chance to get that awnser again?
I just need one SQL line command to change all users to be Visible.
Thank you and sorry

Depends on what you are looking for
Email Notification for instance if you want all members to yes you will need to do two sql queries since some are saved with a off and others are blank

UPDATE w3t_Users SET U_Notify='On' WHERE U_Notify='Off'

UPDATE w3t_Users SET U_Notify='On' WHERE U_Notify=''

You get the general drift from the command line above This will Update everyone to On so you can send email to all.

Thank you
I copy it and saved now
I just need one example, so I can figurout how the other fields will work

Us the top one as an example then. The second one is because I noticed that specific field U_Notify sometimes people do not fill it in and the field is blank in the database so you need to do the second query to update all.

Now another example

UPDATE w3t_Users SET U_Title='newtitle' WHERE U_Number='theirusernumber'

And if you want to set everyone the same... for example set everyone to use the default stylseheet....

UPDATE w3t_Users
SET U_StyleSheet = 'usedefault'

By George I think with all the examples he will be updating MYSQL in his sleep.