Re: Appending to a SET()

[Paul DuBois]

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/