How I can set a column value for all my rows that already exist in the database with some sort of mysql statement

I want to set the value of the column 'character_hold' to 'no' for all my rows in my MYSQL database. Is there a SQL statement I can use i开发者_StackOverflow社区n phpmyadmin to set them all to 'no'?

UPDATE tableName set character_hold='no'