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