recentpopularlog in

therobyouknow : join   7

sql - How does one concatenate database values into a string? - Stack Overflow
Useful for marking which bugzilla bugs have migrated to JIRA.

UPDATE `bugs` SET short_desc = CONCAT('BUG', bug_id, ': ', short_desc ) WHERE product_id = 3 OR product_id = 9

UPDATE `bugs` SET short_desc = CONCAT( short_desc, ' [JIRA]' ) WHERE product_id = 3 OR product_id = 9
concatenate  database  string  within  variable  query  append  prepend  join  combine  link  value  prefix  suffix  field  update  insert  computing  mysql  howto  work 
december 2011 by therobyouknow

Copy this bookmark:





to read