MYSQL multiple updates
<p>I want to update the same column of a table, for different cases in one shot. What is the best way I can achieve this? For example, I want to achieve the same thing as the below statements in one SQL query :</p>

<pre><code>UPDATE DANCER_TYPE SET TYPE = 'BALLET' WHERE LOGIN = 'arachel';
UPDATE DANCER_TYPE SET TYPE = 'EXOTIC_BELLY_DANCER' WHERE LOGIN = 'mandanah';
UPDATE DANCER_TYPE SET TYPE = 'JAZZ' WHERE LOGIN = 'kbianca';
UPDATE DANCER_TYPE SET TYPE = 'FUSION' WHERE LOGIN = 'lmorgan';
UPDATE DANCER_TYPE SET TYPE = 'BOLLYWOOD' WHERE LOGIN = 'idcruz';
UPDATE DANCER_TYPE SET TYPE = 'SAMBA' WHERE LOGIN = 'pcastillo';
</code></pre>

<p>What is the best way to update the DANCER_TYPE column, using a single query, in the most scaleable and efficient manner?</p>