Add a number to unknown number in SQL

Question

Is it possible to add a number to a unknown number in sql column? For example:

In my sql database is a column named "overallRating". I want to add +1 to whatever number is stored in that column. So if number 14 is stored in overallRating column, +1 would make it 15.

Is this possible to do this without retreving this number from sql first? Something like:

UPDATE MyTable SET overallRating+=1 WHERE url='myurl..'

EDIT When solution was already given:

Actually I haven't tried my code above, but I did now and it also works. I made a syntax error on my first try, that's why I thought it's not working.

Answer 1

The += syntax is very new to T-SQL and generally not supported by most PROD systems today and so you just need to spell it out:

UPDATE MyTable SET overallRating=overallRating+1 WHERE ...