[RESOLVED] sql statement

[dst101]

Trying to do a sql statement but not getting anywhere with it.

UPDATE showcase WHERE section='building' SET front = CASE WHEN id = 2 THEN 1 ELSE 0 END

basically I want to set all in table SHOWCASE which has section named BUILDING and ID of 2 to 1 and set all the others in BUILDING section to 0.

Not a hard thing to do eh. It's got me stumped!

Thanks in advance

[cheerio]

isn't the where part supposed to go at the endish?

[dst101]

ahhhh genius! My stupidity! been looking at that for hours...... many thanks