How change multiple Mysql fields?
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.
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
Brilliant Mike, worked perfect, thanks for your help!