stackoverflow.com 960800 - Update query

update-query.sql

UPDATE `profiles`
      SET `name` = CASE `id`
            WHEN 1 THEN 'John'
            WHEN 2 THEN 'Jane'
      END, `gender` = CASE `id`
            WHEN 1 THEN 'Male'
            WHEN 2 THEN 'Female'
      END
WHERE `id`=1 OR `id`=2;