LLLLLLL Posted January 4, 2011 Share Posted January 4, 2011 I'm trying to do something super simple so I'm sure I'll get a correct answer right away. Thanks in advance. I just need the correct syntax to update a table with a value from another table PLUS some static text. My question is purely about the proper syntax. My error-prone syntax (result is a "0" in the field) is the following... update TABLE_TO_UPDATE set some_field = ( select value from TABLE_TO_SELECT where `option` = 'someoptionname' ) + 'this_is_my_static_text' ... where did I go wrong? (I've tried other methods, like CONCAT, but not getting it.) Link to comment https://forums.phpfreaks.com/topic/223312-update-with-concat/ Share on other sites More sharing options...
LLLLLLL Posted January 4, 2011 Author Share Posted January 4, 2011 Nevermind... thought I did this but I guess not: update TABLE_TO_UPDATE set some_field = concat( ( select value from TABLE_TO_SELECT where `option` = 'someoptionname' ), 'this_is_my_static_text' ) Link to comment https://forums.phpfreaks.com/topic/223312-update-with-concat/#findComment-1154421 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.