update all rows via sql
 

stupid question but how do i update all rows via phpmyadmin to set a value in one of the columns?

[sql]
update table set column = value;
[/sql]

Of course you must replace table, column and value with the real names/value :)

thanks kirby, was so basic :(