I recently upgraded to a new version of the quiz program I use. After hours of screwing around, for the most part I think I got it working again(the problem was the mysql database format changed a bit, and there were no type of upgrade instructions so I had to wing the whole thing). Of course there was one new field entered in the mysql database that is text. Right now that field is blank for all of the users. Since its text, I just cant add in a default value. So anyone know of a way to put a word into every colum of a table? Doing it by hand is out of the question because I have to do it about 1000 times.

UPDATE table SET col=<some text>;

thanks, but a couple of questions:
where do I specify the colum that it is going in?

UPDATE <table> SET <col>=<text>

if your table is named 'quiz' and your column is 'name' and the text is 'your text' then

UPDATE quiz SET name="your text"

will fill in the column 'name' with 'your text' on all rows

that command kicks ass, thanks both of you