SQL - Update statement -


Hi - Suppose i have a table, i want to update cat to 22 if id & Gt; 2 , how can I write this statement?

thanks

  id cat ----- ----- 1 12 2 12 3 32 4 32 5 32 one? | A? | | 100 32  

update [tabname] cat set = 22 where id & gt; 2;

Comments