UPDATE foo
   SET col3 = 'EN'
 WHERE LOWER( col4 ) LIKE '%ENG%'