SQL

nested query
UPDATE `infoweb_maillist`.`infoandina_user_user` SET `htmlemail` = '1' WHERE `infoandina_user_user`.`id` IN (SELECT * FROM(SELECT id FROM `infoweb_maillist`.`infoandina_user_user`) AS t1);