MySQL

[iceraider]

With Update in MySQL if one of my rows has a number in it like 5 can I minus that it update like

UPDATE imps SET hits=hits - 1 WHERE .....

???

[ahundiak]

Yes.

UPDATE Employee
SET salary = salary * 1.25
WHERE name = 'Bob'

http://www.mckoi.com/database/SQLSyntax.html#12