mysql query to display output based on two data

Question

in my table the structure is like that

TableA

first_column        second_column       third_column
wwwew                   frfrffee          rfffrfr
dddfdd                  fffrfrfr          rfddwdrv
etc

if users has not set the value of second_column i want to display the result of first_column but if users has specified the value of second_column i want to display the second_column value.

i tried where clause with 'and' & 'or' statement but it is not working.

second_column is child of first column so if users has set parent only then the output will be based on parent but if users has set parent as well as child or only child the output will be based on child input

Asaph · Accepted Answer · 2012-07-29 04:43:06Z

2

I think you can accomplish what you're trying to do using the coalesce() function.

select coalesce(second_column, first_column) from TableA;

answered Jul 29, 2012 at 4:43

Asaph

164k25 gold badges204 silver badges204 bronze badges

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

2 Comments

user1515503 Over a year ago

i have a join statement so i am using where clause to choose the data can you please tell how i can do with where clause as query is very complicated and any changes will not give the proper output

Asaph Over a year ago

Please post your very complicated query.

Collectives™ on Stack Overflow

mysql query to display output based on two data

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related