You do it by: UPDATE my_table set field_1 = field_1 - 1 [...add any where statements here] Bastien pretty much answered your question because the example you provided was, in theory, correct. Besides, unless you're messing with a production system, you could always just try out simple stuff like this on your own and see what happens. More fun that way anyhow. Rich -----Original Message----- From: Justin Turner [mailto:trnr@xxxxxxxxxxxxxxxxxxxxx] Sent: Thursday, September 29, 2005 5:04 PM To: Bastien Koert Cc: php-db@xxxxxxxxxxxxx Subject: Re: adding to the current value How can I do this? Bastien Koert wrote: > yes > > > >> From: Justin Turner <trnr@xxxxxxxxxxxxxxxxxxxxx> >> To: php-db@xxxxxxxxxxxxx >> Subject: adding to the current value >> Date: Thu, 29 Sep 2005 16:26:00 -0400 >> >> I would like to increment the current value of a field X without >> having to retrieve field X beforehand. Can I do this? >> >> Example: >> >> UPDATE my_table set field_1 = (current_field_value -1) WHERE...blah, >> blah, blah.... >> >> ============================================== >> A. Justin Turner >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> > -- ============================================== A. Justin Turner ResNet Coordinator University of Rochester 020 Gates Wing Susan B. Anthony Hall jt@xxxxxxxxxxxxxxxxxxxxx -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
