Need SQL command help...

[uno]

I need to change 30,000 variables all from 0 to 1 in a column in a table in sql...

Can anyone give me the command line?

[kernelpanic]

UPDATE `tablename` SET `columnname`='1';

[swedguy]

UPDATE tablename SET columnname=1 WHERE columnname=0

incase you have other numbers than 0 and 1 in that column

[kernelpanic]

He said that all the variables were 0, though

[Sly]

DELETE tablename

[uno]

hmm i don't want to change the column name, just the values in the column

[uno]

Maybe

Update columnname where value = 0 set value =1?

again i have non clue about the syntax

[Linguist]

Here you go:

update tablename set columnname=1 where columname=0

[uno]

I totally heart you.