Re: Enum Toggle

[Felix Geerinckx]

�ke Lagercrantz wrote:
> Hey!
>
> I've got a 2 option enum variable, say yes/no.
>
> What I want to do is to toggle this enum with a single push of a button (a single update query).

DROP TABLE IF EXISTS foo;
CREATE TABLE foo (id INT NOT NULL PRIMARY KEY, yn ENUM('y', 'n'));
UPDATE foo SET yn = IF(yn = 'y', 'n', IF(yn = 'n', 'y', yn)) WHERE id = <<some_id>>;

--
felix
Please use BBCode to format your messages in this forum.