Update mysql database without replacing?

[MatrixGL]

Well, what I want to do is ADD TO the existing data in a row. From what I know, I have to fetch the data first, then take it and add the extra piece, and add it back in.

That way, I end up with two queries...is there any way to do it with just one query?

[laserlight]

Yes, for example with integers:
UPDATE tablename SET columnname=columnname+1 WHERE rowid=2;

[MatrixGL]

Thank you very much for the fast reply and the solution 🙂

Yay! one less query :p

[MatrixGL]

sorry about the double post, but how do you do it for the text values? Using the "." ? (doesnt seem to work)

[laserlight]

Read up on MySQL's string functions, in particular CONCAT().

[MatrixGL]

worked! Thanks 🙂