MySQL: flag = 1 when id IN(...) otherwise 0 ?

I've got a categories table and there is an indexed flag column that I check to see if the category should be displayed on the index.

I've pretty much got all of my per-unit editors setup and now I'm working on bulk editors. My current design for the bulk flag editor has me creating <ul> hierarchies with checkboxes in the <li> elements for each category.

Here's an example of my checkbox. I plan on having a simple array of category id integers corresponding to categories that should have the flag set.



Now the two-query way to do this is pretty straight forward.




I don't want to use two queries though. Having 1000 rows in this table would be an extremely gross over-estimate of the max anticipated rows.

How can I set the flag to both needed states with a single query in MySQL having an array of category ids that should have the flag set TRUE as input ?

By jove I think I've got it !

Yup, I was just about to mention the CASE.. WHEN.. THEN.. ELSE.. END syntax to you. I recently needed something like this too for something I was working on.

I'd already thought about CASE when I'd started the thread, but I was having problems getting the IN to work for me.

I kept wanting to do something like this instead of the way I have it up there.



This would give me errors like this, which was making me wonder if CASE could support IN at all.