how to update mutiple rows at a time in mysql

See more:

MySQL

Hi..

How to update mutiple rows at a time. i have tried with the follwing update query.

UPDATE mytable
    SET fieldName= CASE other_field
        WHEN 1 THEN 'value'
        WHEN 2 THEN 'value'
        WHEN 3 THEN 'value'
        WHEN 4 THEN 'value'
    END
WHERE id IN (1,2,3, 4);

this query has worked for me but i have 65000 records, if i follow above query i have write 'when' statement for 65000 times. please send me the better solution for updating 65000 records at a time.


Thanks in Advance