I have a MySQL table, that has a column of type set
if the set values are "a", "b", "c"
how do I go about adding a value to the columns.
I mean, if colSet = "a", how do I make it "a","b", if I do not know what the set equals, and the value I am trying to add is passed a a variable?
I need to have a query that will add any value to the set value that already exists.
I can get the set value, add on my new value using php, and then replace the old value with this new value, but this means connecting twice.
can it be done with SQL?
paul13
if the set values are "a", "b", "c"
how do I go about adding a value to the columns.
I mean, if colSet = "a", how do I make it "a","b", if I do not know what the set equals, and the value I am trying to add is passed a a variable?
I need to have a query that will add any value to the set value that already exists.
I can get the set value, add on my new value using php, and then replace the old value with this new value, but this means connecting twice.
can it be done with SQL?
paul13