Urgent Help

[ranjitcool]

hi
i need some help
please

i have a coloumn in my mysql table

it is called speciality

it already has a value called "good"
now i need to add more values to it without deleteing the present value

for example:- first value = GOOD
after new value inserted

it will be GOOD,OK
and so on!

remember the old value shud not be delted!

please help me
i have 3000 records to be updates liek that

urgent
bye

[hemebond]

UPDATE `table` SET `speciality` = concat(`speciality`,",OK") WHERE `speciality` = "GOOD";

[WA]

Hi ranjitcool:
Please read our Posting Guidelines regarding using a more descriptive subject for your thread in the future: http://www.codingforums.com/postguide.htm