From: Daevid Vincent
Date: March 22 1999 10:05pm
Subject: Appending to a SET()
List-Archive: http://lists.mysql.com/mysql/805
Message-Id: <36F6BE8B.D6D8BF93@TheMatrix.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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?

Do I have to perform a query to get what's there and then insert the two
together, or is there a way to "OR" or "AND" some bits or something so that I
can just append the new set parameter without knowing what was there before?

ÐÆ5IÐ         What is http://TheMatrix.com