OK, I cannot find this sql query on the website or in any of my manuals.
I have a table that contains a set datatype eg
CREATE TABLE testjason (
ID int(11) NOT NULL auto_increment,
SomeSetColumn set('a','b','c') NOT NULL default '',
) TYPE=MyISAM;
I neet to perform an UPDATE on this table. The catch is I dont want to UNSET anything.
In other words, I need to update the set values to make sure that 'c' is flagged, but
leave 'a' and 'b' in thier current state.
Dummy data before update
'1','a'
'2','a,b'
'3','a,c'
What I want AFTER update
'1','a,c'
'2','a,b,c'
'3','a,c'
Thanks
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
