[SOLVED] +1 to a row

[CMC]

Hi,

 

Is there a built-in function to add 1 to a row without having to query the db, return a value, add 1 to it, and update the row?

 

I've been looking all over but I haven't been able to efficiently phrase my question so I get optimal results on a search engine :/

 

Thanks for any input

[xtopolis]

All of them?

UPDATE yourTable SET col= col + 1;

 

One of them?

UPDATE yourTable SET col= col + 1 WHERE idCol = 3;

 

Lots?

UPDATE yourTable SET col= col + 1 WHERE idCol IN('3','4','5');

[CMC]

Ah thanks, I was just actually thinking of trying exactly that