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.) Quote Link to comment 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' ) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.