MySQL combine two columns and add into new column

MySQL combine two columns and add into new column

[code language=”sql”]
UPDATE tablename SET combined = CONCAT(zipcode, ‘ – ‘, city, ‘, ‘, state)
[/code]

Output: zipcode – city, state

MySQL combine two columns and add into new column where year is a number

[code language=”sql”]
UPDATE `tablename` SET cat_path = CONCAT(year, ‘/’, name) WHERE concat(”,year * 1) = year
[/code]