MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 22 1999 10:17pm
Subject:Re: Appending to a SET()
View as plain text  
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:
selecting the ENUM valuesChris Cochella22 Mar
  • Re: selecting the ENUM valuesThimble Smith22 Mar
  • Appending to a SET()Daevid Vincent22 Mar
    • Re: Appending to a SET()Paul DuBois22 Mar
  • Binary type? True/False, Yes/No, On/OffDaevid Vincent23 Mar
    • Re: Binary type? True/False, Yes/No, On/OffMicheal Mc Evoy23 Mar