From: Date: March 22 1999 11:17pm
Subject: Re: Appending to a SET()
List-Archive: http://lists.mysql.com/mysql/806
Message-Id: <v04020a10b31c71b4652f@[144.92.43.106]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 4:05 PM -0600 3/22/1999, Daevid Vincent wrote:
>I can't find any examples of appending a new value to a set list...
>
>I see examples of SELECT, but how can I have a table field like so:
>
>  optional SET('Beta','Info'),   # They can be multiple ones. Beta Program,
>Requests Info
>
>then I insert 'Info' into the table, and later the person wishes to be on the
>'Beta' program, how do I append that?


UPDATE tbl_name SET option=CONCAT(optional,",","Beta") WHERE ...

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/