Use CASE in the UPDATE statement : Case « Select Query ...

p1 Search Engine 120000 p2 Programming 95000 p3 SQL 186500 (3 rows affected) 1> 2> -- Use CASE in the UPDATE statement. 3> 4> UPDATE project SET ...

www.java2s.com