Urgent Help

ranjitcool · 02-09-2005, 08:24 AM

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 · 02-09-2005, 09:40 PM

Code:

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

WA · 02-09-2005, 10:18 PM

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

02-09-2005, 08:24 AM	PM User \| #1
ranjitcool New Coder Join Date: Feb 2005 Posts: 41 Thanks: 0 Thanked 0 Times in 0 Posts	Urgent Help 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

02-09-2005, 09:40 PM	PM User \| #2
hemebond Senior Coder Join Date: Jul 2004 Location: New Zealand Posts: 1,315 Thanks: 0 Thanked 2 Times in 2 Posts	Code: UPDATE `table` SET `speciality` = concat(`speciality`,",OK") WHERE `speciality` = "GOOD";

02-09-2005, 10:18 PM	PM User \| #3
WA Administrator Join Date: Mar 2002 Location: North America Posts: 2,347 Thanks: 1 Thanked 12 Times in 12 Posts	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 __________________ - George - JavaScript Kit- JavaScript tutorials and 400+ scripts! - JavaScript Reference- JavaScript reference you can relate to.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread: