Hi,

how can I update a set field such that all table rows get what they had in the set ORed with some other set value.

I.E. If I have a field called SetField and rows:

SetField
A
A,B
A,B,C
B
etc


How can I do what I'm trying to do with this mysql query?

UPDATE MyTable SET SetField = (SetField OR 'D');

Thanks,


Jeff


---------------------------------------------------------------------
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

Reply via email to