Amending field types

[furious5]

I have amended a field type on my mySQL database, to allow a default value of 0 in a field.

Obviously this will apply to all the records now inserted, previously the field type was null.

Is there any way you can alter the existing records as well to tie in with this amendment? There are about 300 items, so it would be very time consuming to re-enter all these values.

I am using phpmyadmin to interface with the db.

[mystrymaster]

use and update query

and update all those fields where fieldname = NULL