niche Posted September 29, 2011 Share Posted September 29, 2011 i need to get the data from two columns (client, stknum) into a column named clistknum. how do I modify this query (UPDATE plan SET clistknum = client) to get the client AND the stknum data into the clistknum column? Link to comment Share on other sites More sharing options...
niche Posted September 29, 2011 Author Share Posted September 29, 2011 this query (UPDATE plan SET clistknum = CONCAT(client,stknum)) does the job , but how do i get an underscore between the data? Link to comment Share on other sites More sharing options...
niche Posted September 29, 2011 Author Share Posted September 29, 2011 CONCAT_WS ! What will they think of next? Link to comment Share on other sites More sharing options...
justsomeguy Posted September 29, 2011 Share Posted September 29, 2011 You can concatenate as many things as you want to. UPDATE plan SET clistknum = CONCAT(client, '_', stknum) Link to comment Share on other sites More sharing options...
niche Posted September 29, 2011 Author Share Posted September 29, 2011 Thanks justsomeguy. I always value your help. I didn't know that and probably wouldn't have found it on my own. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.