Re: Modifying SET columns

[Gerald Clark]

Benjamin Pflugmann wrote:
> 
> Hi.
> 
> On Sun, Aug 22, 1999 at 11:01:26PM -0400, andrian@stripped wrote:
> [...]
> > Again, I need the SET type in order to have multiple
> > selections. There might be other workarounds, but I haven't
> > discovered them yet.
> 
> One other way is to have a second table with mulitiple values for each
> id. Some time ago there was a discussion about the advantages and
> disadvantages regarding this method and SETs. You may want to search
> in the mailing list archieve for it.
> 
> A point against SETs was that you usually only want to use them if the
> set is kind of static (since adding and removing of values needs to
> change all records).
> 
> Another method is to do not use a SET, but handle the string yourself
> (just knowing yourself which values are allowed). This may be easier
> to handle, probably is slower, because MySQL uses binary values
> internally for SETs.
> 
What I have done in the past is change the column to a char,
change the the values I wanted changed, then change the column back
to a set.