Merge columns in MySQL SELECT

Question

I have a table that stores a default configuration and a table that stores a user configuration. I can join the two tables and get all the info I need however I was hoping there might be a cleaner way to overwrite one column with the other when a value exists in the second column.

Example:

Current query result:

id  defaultValue   userValue
1       one           ONE
2       two
3       three        THREE
4       four

Desire query result:

id  value   
1   ONE
2   two
3   THREE
4   four

Maybe there isn't a good way to do this... Thought I'd ask though as it's probably faster to do it in MySQL if a method exists than to do it in PHP.

Ike Walker · Accepted Answer · 2011-03-23 19:02:44Z

6

You can use COALESCE() for this:

SELECT id, COALESCE(uservalue,defaultvalue) AS value
FROM table

answered Mar 23, 2011 at 19:02

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Merge columns in MySQL SELECT

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related