> I am looking for a query something like UPDATE table_name > SET * = * x 1.35 so I don't need to know field names. Ah I see what you mean, if you don't mind doing it in a couple of queries and a bit of programming you could run a 'SHOW COLUMNS FROM table', loop through the results to get the field names, and build your update query on the fly. There is probably a more elegant way to go about this, which I'd be interested in seeing if anyone knows it. Thanks Barry -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Chris Price Sent: 06 January 2009 11:44 To: thelist at lists.evolt.org Subject: Re: [thelist] Increment every value in table (MySQL) Thanks but I am looking for a query something like UPDATE table_name SET * = * x 1.35 so I don't need to know field names. Barry Woolgar wrote: >> I have a table with only numbers in it and I want to increase every value >> > by 35%. > > Assuming MySQL: > > UPDATE table SET `field` = `field` * 1.35; > > Be sure to back up first, just in case my brain is also not functioning... > ;) -- Kind Regards Chris Price Choctaw chris.price at choctaw.co.uk <mailto:chris.price at choctaw.co.uk> www.choctaw.co.uk <http://www.choctaw.co.uk> Tel. 01524 825 245 Mob. 0777 451 4488 Beauty is in the Eye of the Beholder while Excellence is in the Hand of the Professional ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Sent on behalf of Choctaw Media Ltd << ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Choctaw Media Limited is a company registered in England and Wales with company number 04627649 Registered Office: Lonsdale Partners, Priory Close, St Mary's Gate, Lancaster LA1 1XB . United Kingdom -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !