Error Updating multiple value sets in MySQL

[Ronnie268]

I use the following query to update my database. It does not work, giving me a syntax error. Any Ideas?

UPDATE table
SET browser = CASE ID
WHEN '11' THEN 'Google Chrome 2.0'
WHEN '49' THEN 'Google Chrome 2.0'
WHEN '52' THEN 'Google Chrome 2.0'
END, SET os = CASE ID
WHEN '11' THEN 'Microsoft Windows'
WHEN '49' THEN 'Microsoft Windows'
WHEN '52' THEN 'Microsoft Windows'
END, SET language = CASE ID
WHEN '11' THEN 'US English 5'
WHEN '49' THEN 'US English 5'
WHEN '52' THEN 'US English 5'
END WHERE ID IN (11,49,52)

Thanks,

Ronnie268

[Ronnie268]

Sorry. I had put some ticks in the wrong place. Still doesn't work, though.

UPDATE table
SET browser = CASE ID
WHEN 11 THEN 'Google Chrome 2.0'
WHEN 49 THEN 'Google Chrome 2.0'
WHEN 52 THEN 'Google Chrome 2.0'
END, SET os = CASE ID
WHEN 11 THEN 'Microsoft Windows'
WHEN 49 THEN 'Microsoft Windows'
WHEN 52 THEN 'Microsoft Windows'
END, SET language = CASE ID
WHEN 11 THEN 'US English 5'
WHEN 49 THEN 'US English 5'
WHEN 52 THEN 'US English 5'
END WHERE ID IN (11,49,52)

[Ronnie268]

Fixed it now. 'SET' should not have been repeated.

UPDATE table
SET browser = CASE ID
WHEN 11 THEN 'Google Chrome 2.0'
WHEN 49 THEN 'Google Chrome 2.0'
WHEN 52 THEN 'Google Chrome 2.0'
END, os = CASE ID
WHEN 11 THEN 'Microsoft Windows'
WHEN 49 THEN 'Microsoft Windows'
WHEN 52 THEN 'Microsoft Windows'
END, language = CASE ID
WHEN 11 THEN 'US English 5'
WHEN 49 THEN 'US English 5'
WHEN 52 THEN 'US English 5'
END WHERE ID IN (11,49,52)