List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:June 28 1999 10:05pm
Subject:using SET type
View as plain text  
>>>>> "bali" == bali  <iso-8859-1> writes:

bali> Hi All!
bali> Can someone point me to some examples of using set type?

bali> If I define a column like set ('a','b','c','d') and update it with
bali> column='a,b,c', how do i remove 'b' from the values?
bali> Shold I do it with replace(column,'b','') or there's some easier way to do
bali> it?

bali> thanks

That or using:

UPDATE SET COLUMN=COLUMN & 1+4+8;

I have not put on the TODO the functions:

ADD_TO_SET(value,set)

and

REMOVE_FROM_SET(value,set)

Regards,
Monty
Thread
using SET typeTóth Bálint20 Jun
  • using SET typeMichael Widenius29 Jun