How does one add a value to a field that is of type "set"? As a hypothetical example, let's say I have a table that has a field of type set for which valid values are "dog", "cat", "rat". Also, one of the rows already contains the value "dog" so that a select shows only "dog". I'd now like to update that field to include "cat" so that a select show "dog,cat". How do I do that?
I've googled and searched the MySQL manual but haven't found a clear answer. My guess is that I have to do an update with the value being the additional value concatenated on to the existing value. But I haven't found an example, yet. Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/
