I have been trying to figure out the correct sytnax for this for ages and was wondering if anyone could help me out ? The statement works fine, without the where clause, unfortunately I need that where clause to make the statement usefull at a few points in my application.

update tableName
SET value=CASE
WHEN value+1>100 THEN 100
ELSE value+1
WHERE value_enabled<>0
END;

I’ve been wanting to buy a PS2 for a long time. I found a black slim-version PS2 and a silver one for the same price. Previously I’d seen the silver ones costing more. Is there a difference in performance? Should I buy the silver?

I have a case harden easy out that broke of in the head of my car. I have tried to drill it out with a carbine bit. The tip melted off. Any suggestions?