Hi. There are no build-in commands or functions to do so, but it is possbile anyhow. This has been discussed on the list a while ago, so you'll find it in the archives:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80264 Basically it boild down to using CONCAT/REPLACE (will issue warning about commas) or some more complicated expressions (using FIND_IN_SET and binary calculations). Bye, Benjamin. On Thu, May 30, 2002 at 09:11:15AM -0600, [EMAIL PROTECTED] wrote: > 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. [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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
