TalkPHP - View Single Post - Updating multiple columns in a single record

Dave · 07-03-2008, 11:51 PM

I have a table with about 400 fields, but there is a series of fields entitled n1, n2...n50. IOW, there are 50 "consequtively named" fields.

I need to replace all 50 of these fields with a NULL value in one record.

What is the most efficient way to do this? I understand the SQL UPDATE statement, but was kinda hoping that there is a looping technique that I could use, somehow...(?)

Thanks for any help...

Dave

07-03-2008, 11:51 PM	#1 (permalink)
Dave The Acquainted Join Date: Apr 2008 Posts: 110 Thanks: 97	Updating multiple columns in a single record I have a table with about 400 fields, but there is a series of fields entitled n1, n2...n50. IOW, there are 50 "consequtively named" fields. I need to replace all 50 of these fields with a NULL value in one record. What is the most efficient way to do this? I understand the SQL UPDATE statement, but was kinda hoping that there is a looping technique that I could use, somehow...(?) Thanks for any help... Dave