How change multiple Mysql fields?

[Para]

Hi i have a table with 2,733 records.

I need to change a field (published) on all records to show '1' instead of the current 'NULL'

How can i change multiple fields at once?

Thanks in advance for any help with this issue.

[MikeBigg]

just as a where clause in a select statement allows you to select certain rows, so it does with an update statement:

select * from mytable where mycolumn is null

will list all the rows with null in the column.

update mytable set mycolumn = 1 where mycolum is null

will update all the rows with null on the column

hth

Mike

[Para]

Brilliant Mike, worked perfect, thanks for your help!