[SOLVED] updating with +1

[wrathican]

Hi there,

 

Thanks for looking

 

im trying to increment an int field with an sql query:

update categories set blog_count='blog_count+1' where id='24';

 

my query runs sucessfully but does not increment the field.

 

trying this on MySQL 4.0.20

 

i guess im either doing it wrong or my version doesnt support it.

 

Help?

 

Thanks

[Mchl]

update categories set blog_count=blog_count+'1' where id='24';

[wrathican]

bah! as if it was that simple.

 

i had been searching on google for about an hour trying to see where i was going wrong. none of the examples i saw put only the +1 in '

 

Thanks alot!

[Mchl]

Well.. I suppose it;s because this:

update categories set blog_count=blog_count+1 where id='24';

 

will work as well

[corbin]

When dealing with numeric columns, the values should not be in quotes since they have to be parsed into numbers.  Either way works though (in most cases).