Changing data in one field


#1

Hi.

Is there a way in the phpmyadmin screen to change data in just one field?

Specifically… in a table named:
wp_posts

there is a field named:
post_author

There are 1477 records with post_author = 3.

I would like to change all of those records to = 1.

Thanks for any assistance you can provide.

Rori