I am getting the

 /* SQL Error (1235): This version of MySQL doesn't yet support 'LIMIT 
& IN/ALL/ANY/SOME subquery' */

The update query I writing is this

update id_card 
set division_category='678' 
where CODE  IN ( SELECT code  
                 FROM id_card 
                 WHERE CODE LIKE '