CODEWITHSUNDEEP
mysql
Endophage
Endophage

Reputation: 21473

Merge columns in MySQL SELECT

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.

Upvotes: 2

Views: 3486

Answers (1)

Ike Walker
Ike Walker

Reputation: 65547

You can use COALESCE() for this:

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

Upvotes: 6

Related Questions