I am naive in SQL, looking for expert help before doing playing with the Sql table.

What is the correct Sql Syntax to update and replace values in `jos_fb_users`

I want to replace values of Null and Default to Yes and 0 respectively.
Null => Yes
Default => 0

of following five fields
moderator
ordering
posts
avatar
karma
karma_time

What is the correct Sql Syntax to update values of these fields of our PHP5 server

Thank you

What are you trying to accomplish?

Thanks for replying..

At present all my counts for views, number of posts by users are 0 . There is no increment. After so long time (almost one year searching in the fire board forum) when I compared fb tables with default installation with my actual site's sql table, I have realized the culprit is Null( instead of Yes) and 0 in default row for moderator, ordering, posts, avatar, karma, karma_time

So I am looking for syntax command to change Null to Yes and '0' in default values of `jos_fb_users`