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,
>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/