[RESOLVED] Quick increment MySQL field value + 1

[pipe_girl]

Hello,

Is it possible to increment a field value in a MySQL table by 1 in one line? For example:

mysql_query("UPDATE table SET field_name='field_value++' WHERE fieldID='criteria'");

...rather than pulling the value of that field out, incrementing it, and then inserting it back in.

Any help is appreciated.

Thanks!
Pipe

[devinemke]

UPDATE table SET field_name = field_name + 1 WHERE fieldID = 'criteria'

[pipe_girl]

Excellent! Thank you sir.

[jeffery2k9]

hai there ,
u have a wonderful idea........
This was exactly what i was looking for...........
Thanx a lot.......................................................

[kostis12345]

If I wanted to add 1 to all the rows I would use the following ?

UPDATE tablename SET columnname = columnname + 1

[foyer]

did you try it? is it worth waiting for a reply or should you just try it out and see what happens

[kostis12345]

Tried it and it works.