Update column including its own column info
Posted: Tue Jul 15, 2008 11:29 am
Hi,
I remember reading this somewhere but couldn't find it again so I was hoping someone could point me in the right direction.
I want to do something simple like
instead of doing a select for the column, adding the string and then updating the new information. My hosting service uses MySQL 4.0.24 if that makes any difference in SQL version.
column1 is empty by default but is a varchar type
Regards,
I remember reading this somewhere but couldn't find it again so I was hoping someone could point me in the right direction.
I want to do something simple like
Code: Select all
update tablename
set column1 = column1 + 'this string'
where columnkey = 106
column1 is empty by default but is a varchar type
Regards,