I wanted to see if there is a cleaner and more effective way of writing the SQL statement below. (MySQL)
UPDATE login SET is_admin=1
WHERE
memberid = 1
OR
memberid = 6
OR
memberid = 10
OR
memberid = 12
OR
memberid = 7
OR
memberid = 3;
Simply want a nicer way of solving it. Optimize :)