mysql
 

whats the command to add a value to a 2D table, a single values i mean, or is it only possible to replace the etire row? ive tried everything i can think of and it seems google and the help file have failed me. so it would be much appreciated if anyone knows, again i have a table with 2 indexes, and i need to replace only a few of the values, and commands such as "replace into 'table' where indexA = blah and indexB= blahblah values val1, val2, val3", just keep giving errors, i hope i explained that clearly enough and if anyone knows, thanks in advance.

update TABLENAME set COLUMN = VALUE where CONDITION
is probably what you want

omg, thank you! that was just simple enough to confuse me for hours! =/