Can you update one column in every row of a database, without using a while statement?

[cstegner]

Hi, once a week I want to update a certain column in every one of my members database rows. Now I was wondering if there was a certain query you could feed mysql to do this rather then using a while statement to go through every row.

For the odvious reason that if ther were one day 5 million users, well you get the idea.

You guys are always a huge help, and I am starting to try and help out those who I can.

-Chris

[.josh]

update tablename set columnname = 'blah'

[cstegner]

I feel like a moron, at any rate...thank you.

-Chris