Adding a value to all at once

[xdentan]

I am trying to add five to every entry in the database so I have tried scripts like this

UPDATE variables
SET turns += '5'

and

UPDATE variables
SET turns =+ '5'

and also

UPDATE variables
SET turns + '5'

Is there a way to add five to all the entries at once or do I have to make a script that updates each row individually?

[BSTRhino]

You're so close! Try this.

UPDATE `variables` 
SET `turns` = `turns` + '5'